Make a Macro Do Simple Tasks
- Creating a Simple Macro
- Changing Multiple Properties at Once
- Editing a Recorded Macro
- Recording Actions in A Macro
Make a Macro Do Complex Tasks
- Creating a Simple Macro
- Divide and Conquer
- Opening the Report File
- Filling in Missing Labels
- Adding a Column of Dates
- Appending to the Database
- 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 Functionality
- 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.
|
Course
Outline