Word VBA Macro Programming

Everything you need to know to confidentally start writing your own macros to automate Microsoft Word processes.

| taught by G Com Solutions

Watch Intro Video  |   Free Trial

$75.00
SKU
Word VBA Macro Programming

Course description

The video tutorials in this course are designed to give you all the ammunition you'll need to start creating your own custom macros to automate Microsoft Word tasks and operations. Word users learn VBA macro programming for a number of reasons: some people are looking to enhance their career prospects; some are looking to save themselves time; others are aiming to save their company money and increase productivity.

Whatever your reasons for considering learning more about Word VBA macros, this course aims to equip you with everything you need to get started.


COURSE  CURRICULUM

Getting Started
  1. What is Involved in Learning Word VBA
  2. Getting Set Up
  3. The Developer Tab
  4. Recording a Macro
  5. Attaching a Macro to the Quick Access Toolbar
  6. Assigning a Keyboard Shortcut to a Macro
  7. Editing a Recorded Macro
  8. The Benefits and Limitations of the Macro Recorder
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
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
Subroutines and Functions
  1. Defining and Calling Subroutines
  2. Defining and Calling Functions
  3. Passing Arguments
  4. Using Optional Arguments
  5. Variable Scope
Conditionals, Loops and Arrays
  1. If Statements
  2. Select Case Statements
  3. For ... Next Loops
  4. Do ... Loop Statements
  5. While ... Wend Statements
  6. Using Array Variables
  7. Dynamic Arrays
The Word Object Model
  1. Understanding the Word Object Model
  2. Working with Object Methods
  3. 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
Events, Dialogs and User Forms
  1. Overview of Event Programming
  2. Working with Document Events
  3. Using Built-in Dialogs
  4. Creating a User Form
  5. Creating User Form Event Handlers
  6. Validating User Input
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
Additional Step-by-Step Practice
  1. Obtaining the Course Files
  2. Overview of the Project
  3. Creating the Launch Macro
  4. Creating the User Form
  5. Listing File Names in the Listbox Control
  6. Programming the Remove Button
  7. Programmming the Move Up and Move Down Buttons
  8. Programming the Cancel Button
  9. Programming the Main Action Button

.

Write Your Own Review
You're reviewing:Word VBA Macro Programming