Word VBA Macro Programming

Everything you need to know to confidentally start writing your own macros to automate Microsoft Word processes. | taught by Grant Gamble

Free Preview Buy £75.00

Watch Intro Video

Grant Gamble

Grant Gamble

Senior Trainer

About the instructor

Grant Gamble is an experienced IT trainer, developer, consultant and author able to deliver a wide range of training courses. He has a vast experience of delivering public and on-site IT training content at different skill levels, to groups of varying sizes.

His speciality is running week-long, intensive training workshops on topics like Microsoft VBA, web development and Adobe Creative Suite automation.

If you have any queries regarding this course, please contact us at support@gcomsolutions.co.uk.

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 Contents

70 Videos

1 Download

10.0 hrs

Course Curriculum

1. Getting Started

67:48

Download course files here

1. Welcome FREE PREVIEW

2. What is Involved in Learning Word VBA FREE PREVIEW

3. Getting Set Up FREE PREVIEW

4. The Developer Tab FREE PREVIEW

5. Recording a Macro FREE PREVIEW

6. Attaching a Macro to the Quick Access Toolbar FREE PREVIEW

7. Assigning a Keyboard Shortcut to a Macro FREE PREVIEW

8. Editing a Recorded Macro FREE PREVIEW

9. The Benefits and Limitations of the Macro Recorder FREE PREVIEW

2. Writing Macros in the Visual Basic Editor

92:47

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

84:00

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

42:33

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

99:38

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

91:42

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

118:35

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

74:22

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

91:33

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

10-Programming the main Action button Part 4