Excel VBA – Class 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 basics
- 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