Microsoft Excel Macros
Creating and using personal macros
- what is a macro?
- recording a personal macro
- running a personal macro
- displaying macro instructions
- editing a macro
- including relative cell references in macros
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 Visual Basic Editor
- displaying a data prompt during macro execution
- using a conditional statement in a macro
- using a control loop in a macro
- additional control statements
Placing controls on a worksheet
- placing a combo box and check box on a worksheet/linking a control to worksheet data
Creating a macros toolbar
- creating a new toolbar
- adding a button to a toolbar/assigning a macro to a toolbar button
Creating a macros menu
- creating a new menu
- adding an item to a menu/assigning a macro to a menu item
Using the Visual Basic help system
- displaying Visual Basic help information
