|

|
 |
Sales: 800-355-9855
|
|
EVB201i: Introduction to Excel VBA |
Book List |
Course Links
|
|
Tuition: $295.00 per student |
Length: 1 day |
|
Synopsis:
Introduction to VBA programming in Excel. Covers variables, data types, control structures, object oriented concepts, debugging, etc. Students should already be proficient in Excel. |
Formats:
Corporate groups (min. 3 students) at your facility only. |
Scheduling:
Custom scheduled to suit your needs. |
Group
Discounts:
2-4 students 20%, 5-8 30%, >8 quote |
|
|
|
Session 1 | VBA Basics | 3.0 Hours | |
- Visual Basic Editor - Visual Basic for Applications, Object Programming, The Object Browser
- Object Programming - Properties, Methods, Events
- The Object Browser - Using the Object Browser
- Programming Basics - Variables, Data Types, Operators, Interaction functions, Scope
|   | Session 2 | Using VBA | 3.0 Hours | |
- Control structures - If, Select, Loops
- Custom Dialogs - Forms, Controls, Event Handlers
- Debugging - Errors, Debugging, Breakpoints, Watch Lists, Step Into, Immediate Window, Locals Window
- On Error - Using On Error
|   |
Materials:
Student manual, training certificate.
|
Location:
Classes are normally taught on-site at your facilities or via online Remote Learning. We may also be able to host the class in a rented university classroom near you. Please see FAQs if interested.
|
Related Services |
Need
help with a project? We may also provide programming
and consulting services covering the above material. See
Programming and Consulting for more information.
|
|
Copyright 2022
D.H.D'Urso & Associates
P.O. Box 6142, Laguna Niguel,
CA 92607
949-408-1350
Serving: Orange, Los Angeles, San Diego, Riverside, San Bernardino, Imperial and Ventura counties
and beyond. |
| | |
| |
| |
|
|