Make a Macro Do Simple Tasks
How Visual Basic for Applications Tasks to Excel
Creating a Simple Macro
Changing Multiple Properties at Once
Editing a Recorded Macro
Recording Actions in A Macro

Make a Macro Do Complex Tasks
Divide and Conquer
Task One: Opening the Report File
Task Two: Filling in Missing Labels
Task Three: Adding a Column of Dates
Task Four: Appending to the Database
Task Five: Deleting the Worksheet
Assembling the Pieces

Control Visual Basic
Using Conditionals
Creating Loops
Managing Large Loops

Extend Excel and Visual Basic
Creating Custom Functions
Handling Errors

Launch Macros with Events
Creating Custom Toolbars and Menus
Creating Custom Command Buttons
Handling Worksheet and Workbook Events

Create a Custom Form
Creating a Form’s User interface
Preparing a Form’s Functionality0
Implementing a Form

Workshop
Two hours of the last day may be open to user-defined tasks. We encourage the users to bring to class some simple tasks they would like to automate, and the instructor will select some for the class to tackle.