| Dates for this class: | ||||
|
| Course Details [choose new course] [printable version] |
| Excel 2003: VBA Programming |
| Course Number: AP0061 |
| Category: Business & Office Applications |
| Duration: 1.00 day |
Description
This ILT Series course, rated 4.8/5.0 in overall quality by ProCert Labs, is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, creating user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
Outline
- Unit 1: Visual Basic Editor
- Topic A: Visual Basic for Applications
- Topic B: Object Programming
- Topic C: The Object Browser
- Unit 2: Programming basics
- Topic A: Data
- Topic B: Scope of variables
- Topic C: Scope of procedures
- Unit 3: Control structures
- Topic A: Decision structures
- Topic B: Loop structures
- Unit 4: Custom dialog boxes
- Topic A: User forms
- Topic B: Events
- Unit 5: Debugging and error-handling
- Topic A: Errors
- Topic B: Debugging
- Topic C: Error-handling