Word VBA Macro Programming

1. Getting Started

1. Welcome
2. What is Involved in Learning Word VBA
3. Getting Set Up
4. The Developer Tab
5. Recording a Macro
6. Attaching a Macro to the Quick Access Toolbar
7. Assigning a Keyboard Shortcut to a Macro
8. Editing a Recorded Macro
9. The Benefits and Limitations of the Macro Recorder

2. Writing Macros in the Visual Basic Editor

1. Understanding the Project Explorer
2. Other VBA Windows and Toolbars
3. Macros and Subroutines
4. Getting Help on Macros and the Word VBA Object Model
5. Setting VBE Options
6. Setting Project Options

3. Variables and Constants

1. Initializing and Populating Variables
2. Variable Data Types
3. String Variables
4. Number Variables
5. Date Variables
6. Declaring Constants
7. Object Variables

4. Subroutines and Functions

1. Defining and Calling Subroutines
2. Defining and Calling Functions
3. Passing Arguments
4. Using Optional Arguments
5. Variable Scope

5. Conditionals, Loops and Arrays

1. If Statements
2. Select Case Statements
3. For ... Next Loops (Part 1)
3. For ... Next Loops (Part 2)
4. Do ... Loop Statements
5. While ... Wend Statements
6. Using Array Variables (Part 1)
6. Using Array Variables (Part 2)
7. Dynamic Arrays

6. The Word Object Model

1. Understanding the Word Object Model
2. Working with Object Methods
6. Working with Object Properties
4. Referring to Objects within a Collection
5. Referencing versus Selection or Activation
6. Testing for the Existence of an Object
7. Removing Objects from a Collection

7. Events, Dialogs and User Forms

1. Overview of Event Programming
2. Working with Document Events (Part 1)
2. Working with Document Events (Part 2)
3. Using Built-in Dialogs
4. Creating a User Form (Part 1)
4. Creating a User Form (Part 2)
5. Creating User Form Event Handlers (Part 1)
5. Creating User Form Event Handlers (Part 2)
6. Validating User Input

8. Error Handling and Debugging

1. Implementing Error Handling
2. VBE Error Trapping Options
3. Using On Error Resume Next
4. Using the Err Object
5. Debugging via Output
6. Stepping through Code
7. Using Watches to Monitor Values

9. Additional Step-by-Step Practice

1. Obtaining the Course Files
2. Overview of the Project
3. Creating the Launch Macro
5. Creating the User Form
5. Listing File Names in the Listbox Control
7. Programming the Remove Button (Part 1)
07-Programming the Remove button
8. Programmming the Move Up and Move Down Buttons
9. Programming the Cancel Button
10. Programming the Main Action Button
11. Programming the main Action button Part 4