£75.00 – £2,250.00
The video tutorials in this Word VBA online training 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 OUTLINE
1. Getting Started
Downloading the Course Files
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
4. Creating the User Form
5. Listing File Names in the Listbox Control
6. Programming the Preview Listbox
7. Programming the Remove button
8. Programmming the Move Up and Move Down Buttons
9. Programming the Cancel Button
10. Programming the Main Action Button (Part 1)
11. Programming the Main Action Button (Part 2)
User | Single User, 2 Users, 5 Users, 10 Users, 25 Users, 50 Users, 100 Users |
---|