| Recording Simple Macros Recording and running a Personal Macro
 Displaying Macro Instructions
 Editing a Macro
 Using Absolute and Relative references
 
 Creating and using Workbook Macros
 Recording and running a Workbook Macro
 Adding a Macro button to a worksheet
 
 Using Visual Basic to write Macros
 Opening a new Module in the VB editor
 Displaying a Data Prompt
 Using a Conditional statement
 Using a Control loop in a Macro
 Additional Control statements
 | Placing Controls on a Worksheet Placing a Combo box list and Check box on a Worksheeet/Linking a Control to data
 
 Creating a Macro toolbar
 Adding a Macro button to the Quick Access toolbar
 Assigning a Macro to a 
 toolbar
 
 Creating a Macro menu
 Creating a new menu
 Adding an image to a Macro toolbar button
 
 Using the Visual Basic Help system
 Displaying Visual Basic help information
 |