Microsoft
Excel
Macros

COURSE OUTLINE

Home   Back   Disclaimer  

Introduction

Creating and using personal macros

• what is a macro ?
• recording a personal macro
• running a personal macro
• displaying macro instructions
• editing a macro
• using absolute and 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

Home   Courses   Word   Excel   PowerPoint   Access   Outlook   Windows   Disclaimer