Getting Started
  • Welcome to Microsoft Word VBA Macro Programming
  • What is involved in learning Word VBA?
  • Getting Set Up (DOWNLOAD EXERCISE FILES HERE!)
  • The Developer Tab and Macro Security
  • Recording a Macro
  • Attaching Macros to the Quick Access Toolbar
  • Assigning a keyboard shortcut to a macro
  • Editing a Recorded Macro
  • The Benefits and Limitations of the Macro Recorder
Writing Macros in the Visual Basic Editor
  • Understanding the Project Explorer
  • Other VBE Windows and Toolbars
  • Macros and Subroutines
  • Getting Help on VBA and the Word Object Model (Part 1)
  • Getting Help on VBA and the Word Object Model (Part 2)
  • Setting VBE Options (Part 1)
  • Setting VBE Options (Part 2)
  • Setting Project Options
Variables and Constants
  • Initialising and Populating Variables
  • Variable Data Types (Part 1)
  • Variable Data Types (Part 2)
  • String Variables
  • Number Variables
  • Date Variables
  • Declaring Constants
  • Using Object Variables
Subroutines and Functions
  • Defining and Calling Subroutines
  • Defining and Calling Functions
  • Passing Arguments
  • Using Optional Arguments
  • Variable Scope
Conditionals, Loops and Arrays
  • If Statements
  • Select Case Statements
  • For...Next Statements (Part 1)
  • For...Next Statements (Part 2)
  • Do…Loop Statements
  • While…Wend Statements
  • Using Array Variables (Part 1)
  • Using Array Variables (Part 2)
  • Working with Dynamic Arrays
The Word Object Model
  • Understanding the Word Object Model
  • Working with Object Methods
  • Working with Object Properties
  • Referring to objects within a collection
  • Referencing Versus Selection and Activation
  • Testing for the Existence of an Object
  • Removing Objects from a Collection
Events, Dialogs and UserForms
  • Overview of Event Programming
  • Working with Document Events (Part 1)
  • Working with Document Events (Part 2)
  • Using Built-in Dialogs
  • Creating a UserForm (Part 1)
  • Creating a UserForm (Part 2)
  • Creating UserForm Event-Handlers (Part 1)
  • Creating UserForm Event-Handlers (Part 2)
  • Validating User Input
Error Handling and Debugging
  • Implementing Error Handling
  • VBE Error Trapping Options
  • Using On Error Resume Next
  • Using the Err object
  • Debugging via output
  • Stepping through Code
  • Using Watches to Monitor Values
Additional Step-by-Step Practice
  • Obtaining the course files
  • Overview of Project
  • Creating the Launch Macro
  • Creating the UserForm
  • Listing File Names in the Listbox Control
  • Updating the Preview Text Box
  • Programming the Remove Button
  • Programming the Move Up and Move Down Buttons
  • Programming the Cancel Button
  • Programming the Main Action Button Part 1
  • Programming the Main Action Button Part 2
More from Grant Gamble
  • Advanced Word VBA Macro Programming
  • Power BI Excel Integration
  • Power BI SQL Server Integration
  • Power BI DAX What-if Parameters
  • Power BI Sales Pipeline Analytics and Visualization
  • Welcome to Power BI Parameters, Templates and RLS