|
|
|
|
|
|
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 at our studio in San Juan Capistrano, Orange County, California. 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.
|
|
|
|
