| Macros |
| |
Overview of macros
Recording a new macro
Inserting extra steps
Deleting steps
Attaching a macro to a button
Customising a button |
|
| VBA Editor overview |
| |
The user interface
Toolbars and menus
The Project Explorer
The Object browser
The Properties window
|
|
| VBA essentials |
| |
Modular programming
Creating sub routines
Handling arguments
Creating functions
Functions that return a value
Adding comments
|
|
| Storing data |
| |
Declaring variables
Overview of data types
Storing text
Storing numbers
Storing dates
|
|
| Programming structures |
| |
Overview of control structures
Using conditional expressions
Logical operators
Using looping structures
Breaking out of a loop |
|
| Word objects |
| |
Word documents
The active document
Opening windows
The Range object
The Selection object
Manipulating text
|
|