• Automating tasks you perform frequently 
• Macro viruses 
• Command Macros vs. User-Defined Functions 
• Running a command macro 

Recording a Command Macro 

• Visual Basic Toolbar 
• Viewing your Code 

Using the Visual Basic Editor 

• Touring the Visual Basic Editor 
• Project Explorer 
• Properties Window 
• Code Area 
• Changing Visual Basic Environment Options 
• Calling a Sub Procedure 
• Writing a New Macro Procedure 

Running a Command Macro 

• Running a Macro from the Macro Dialog Box 
• Running a Macro with a Shortcut Key 

Recording More Command Macros 

• Creating Macros that Open Other Workbooks 
• Creating Macros that Tile Worksheet Windows 
• Relative vs Absolute Reference Recording 

Assigning Macros to Buttons and Menus 

• Adding controls using Forms toolbar 
• Running a macro from a button or graphic control 
• Running a macro from a toolbar button 
• Adding a macro to a menu 

Using the Personal Macro Workbook 

Debugging and Editing a Macro 

Creating and Using a Function Macro 

Using Dialog Box Controls 

• Creating range names 
• Using the forms toolbar 
• Creating a combo box 
• Creating scroll bars and spinner controls 

VBA Programming from Scratch 

• Using the Offset()property 
• Using the Range object 
• Using the Dim statement 
• Using the Cells()property 
• Learning more about VBA programming