Office 2000 - Macro Programming using Visual Basic for Applications Training Class

Lesson 1: Introduction to Visual Basic for Applications

Running a macro
Recording a macro
Examining module design

Lesson 2: Assigning macros

Specifying the location of recorded macros
Assigning macros to menus, buttons, and toolbars

Lesson 3: Creating decision-making code

The If???Then decision structure
The If???Then???Else decision structure
The Select Case decision structure

Lesson 4: Using loop structures

Using a For???Next statement
Using a Do???Loop statement
Using a For Each???Next statement

Lesson 5: Macro management

Personal Macro Workbook
Assigning Sub procedures to run automatically

Lesson 6: Recording a macro in Word 2000

Running a macro
Recording a macro

Lesson 7: Interactive macros

Creating a custom message box
Creating a custom input box
Extracting data from Excel