| Basics |
| |
Excel VBA overview
Understanding macro steps
Modifying macro steps
Storing values in variables
Adding comments to your code
Stepping through macros
Getting help on macros
Objects, properties and methods
About Excel objects
|
|
| Range object |
| |
The Selection
property
The Range property
Targetting cells |
|
| |
Counting the cells in a selection
Using the Offset statement
Retrieving the value of a cell
Retrieving a formula from a cell
Setting the value of cells |
|
| Using Visual Basic |
| |
Language structure
Using variables
Declaring variables
Data types
Making decisions
If statements
Looping structures |
|
| Interactivity |
| |
Assigning a macro to a menu
Assigning a macro to a toolbar
Assigning macros to other objects
Built-in dialogue boxes
Using form controls |
|