Course Catalog

Macros Excel 2002

Topics

• Introduction
• 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
• Final case study

Course Length

For More Information

Other Excel 2002 Courses: