VBAPE - VBA Programming Using Excel 2007
This course is designed to give experienced Excel users proficiency in creating procedures that run in response to specific events, working with control structures, developing user forms to accept or display data, validating the data entry in user forms, and debugging and handling errors in code.
Visual Basic Editor
Visual Basic for Applications
Object programming
The Object Browser
Programming basics
Data basics
Scope of variables
Scope of procedures
Control structures
Decision structures
Loop structures
Custom dialog boxes
User forms
Events
Debugging and error handling
Errors
Debugging
Error handling