1.2: What's Involved in Learning VBA

1.3: Getting Set up

1.4: The Developer Tab

1.5: Recording a Macro

1.6: Adding Macros to the Quick Access Toolbar

1.7: Assigning a Keyboard Shortcut to a Macro

1.8: Editing a Recorded Macro

1.9 Benefits and Limitations of the Macro Recorder

2.1: The Project Explorer

2.2: Other Windows in the VBE

2.3: Macros and Sub-Procedures

2.4: Getting Help

2.5: VBE Options

2.6: Project Properties

3.1: Declaring and Populating Variables

3.2: Data Types Part 1

3.2: Data Types Part 2

3.3: String Variables

3.4: Number Variables

3.5: Date Variables

3.6: Constants

3.7: Object Variables

4.1: Sub-routines

4.2: Functions

4.3: Using Arguments

4.4: Optional Arguments

4.5: Variable Scope

5.1: If Statements

5.2: Select Case Statements

5.3: For ... Next Loops Part 1

5.3: For ... Next Loops Part 2

5.4: Do Loops

5.5: While ... Wend Loops

5.6: Array Variables Part 1

5.6: Array Variables Part 2

5.7: Dynamic Arrays

6.1: The Word Object Model

6.2: Object Methods

6.3: Object Properties

6.4: Referring to Objects

6.5: Selecting Objects

6.6: Testing if and Object Exists

6.7: Removing Objects

7.1: Events Overview

7.2: Document Events Part 1

7.2: Document Events Part 2

7.3: Using Built-in Dialogs

7.4: Creating a User Form Part 1

7.4: Creating a User Form Part 2

7.5: Event Handlers Part 1

7.5: Event Handlers Part 2

7.6: Data Validation

8.1: Implementing Error Handling

8.2: VBA Error Trapping Settings

8.3: On Error Resume Next

8.4: The Err Object

8.5: Monitoring Output

8.6: Stepping Through Code

8.7: Using Watches