|
|
|
|
EVB201i: Introduction to Excel VBA
|
|
|
|
|
Tuition:
$245.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. 2 students) at your facility or ours in San Juan Capistrano, Orange County, California. Single individuals may arrange a private class billed hourly at private training rates.
|
|
Scheduling:
Classes flexibly scheduled by arrangement.
|
|
Group
Discounts:
Yes - see FAQ's.
|
|
|
|
| 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 - Uing 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 can be taught on-site at your facilities
or at our location in San Juan Capistrano, Orange
County. We also travel beyond Southern California.
|
|
|
|
