VBA for Microsoft Word Course

Lesson 1 • Procedures: Subs and Functions

Distinguishes Sub procedures from Function procedures and explains scope. Students write reusable code blocks called throughout later projects.

Lesson 2 • VBA Syntax and Language Basics

Teaches variables, data types, operators, and comments as the grammar of VBA. Provides the syntax foundation required for every later chapter.

Lesson 3 • Macros and the Macro Recorder

Covers recording, running, and inspecting macros generated by Word. Connects recorded code to hand-written VBA concepts introduced next.

Lesson 4 • Saving and Distributing Macro-Enabled Files

Explains DOCM and DOTM file formats and trust center configuration. Ensures students can share working macro files with colleagues safely.

Lesson 1 • Conditional Statements

Covers If/Then/Else and Select Case structures for branching logic. Enables macros to make decisions based on document content or user input.

Lesson 2 • Do While and Do Until Loops

Introduces condition-driven loops that run until a state changes. Prepares students for search-and-process patterns used in document automation.

Lesson 3 • Debugging Techniques

Covers breakpoints, step execution, and watch expressions to trace logic errors. Builds diagnostic skills applied to every subsequent coding exercise.

Lesson 4 • For and For Each Loops

Teaches counted iteration with For/Next and collection iteration with For Each. Directly supports processing multiple paragraphs, words, or tables.

Lesson 1 • Paragraphs, Sentences, and Words

Covers the Paragraphs, Sentences, and Words collections and their properties. Provides granular access to text units needed for formatting and analysis tasks.

Lesson 2 • Characters and the Story Ranges

Introduces character-level access and the StoryRanges collection for headers and footers. Completes the object model map from document to individual character.

Lesson 3 • Application and Document Objects

Maps the top-level Application object and the Documents collection. Establishes the root of every object reference used in Word VBA.

Lesson 4 • Working with the Selection Object

Teaches how to read and manipulate the current cursor selection. Connects user interaction to programmatic text operations performed later.

Lesson 1 • Find and Replace with VBA

Teaches the Find object and its Execute method for programmatic search and replace. Enables batch text corrections and pattern-based document updates.

Lesson 2 • Styles and Style Application

Explains the Styles collection and how to apply built-in and custom styles via code. Connects formatting automation to Word's native style system for consistency.

Lesson 3 • Inserting and Deleting Text

Covers InsertBefore, InsertAfter, and Delete methods on Range and Selection. Builds the core text-editing toolkit used in document generation workflows.

Lesson 4 • Working with Tables in Code

Covers the Tables collection, Cell object, and row/column iteration for data-driven tables. Prepares students for report generation and structured document automation.

Lesson 1 • Common Form Controls

Covers TextBox, ComboBox, ListBox, CheckBox, and OptionButton controls and their key properties. Enables forms that capture diverse data types from users.

Lesson 2 • Introduction to UserForms

Introduces the UserForm designer and its toolbox controls. Establishes the foundation for building professional dialog interfaces in later sections.

Lesson 3 • Input Validation and Error Feedback

Implements validation logic inside forms to prevent bad data from reaching document code. Produces polished, user-friendly tools that handle edge cases gracefully.

Lesson 4 • Form Events and Button Actions

Explains Click, Change, and Initialize events to drive form behavior. Connects user actions to document operations performed when the form is submitted.

Lesson 1 • Assembling Multi-Section Documents

Uses InsertFile and subdocument techniques to combine multiple files into one. Supports report assembly workflows where sections are authored separately.

Lesson 2 • Building Documents from Templates

Teaches opening a DOTX template, populating placeholders, and saving as a new DOCX. Produces a complete document generation workflow from a single macro call.

Lesson 3 • Content Controls as Data Placeholders

Introduces rich text, plain text, and dropdown content controls and their VBA interface. Provides a structured alternative to bookmarks for template-based automation.

Lesson 4 • Working with Bookmarks

Covers the Bookmarks collection for marking and targeting named positions in a document. Enables precise content insertion without relying on fragile text searches.

Lesson 1 • Batch Processing Multiple Documents

Combines file system iteration with document open/close cycles to process folders of files. Automates repetitive editing tasks across entire document libraries.

Lesson 2 • Importing CSV and Delimited Data

Parses CSV files using Split and string functions to extract structured data. Feeds imported records into tables or bookmarks for automated report generation.

Lesson 3 • Automating Excel Data into Word

Uses early and late binding to open Excel workbooks and read cell data into Word. Enables data-driven document population from spreadsheet sources.

Lesson 4 • Reading and Writing Text Files

Teaches Open, Print, Write, and Close statements for sequential text file I/O. Supports importing data into documents and exporting document content to logs.

Lesson 1 • Code Organization and Maintainability

Applies modular design, naming conventions, and inline documentation to production code. Ensures long-term readability and ease of maintenance by other developers.

Lesson 2 • Custom Ribbon Buttons with XML

Introduces Custom UI XML to add ribbon tabs, groups, and buttons tied to macros. Delivers a professional interface that exposes automation tools to end users.

Lesson 3 • Building and Deploying Word Add-ins

Packages macros into a DOTM add-in and configures automatic loading on Word startup. Produces a distributable solution installable across an organization.

Lesson 4 • Performance Optimization Techniques

Covers ScreenUpdating, DisplayAlerts, and object caching to speed up macro execution. Reduces runtime on large documents and batch operations significantly.