| 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 |