Microsoft Word VBA Macro Programming

Grant Gamble

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
60 Videos (11h 11m)
    • 1.1: Welcome to Microsoft Word VBA Macro Programming

      3:51
    • 1.2: What's Involved in Learning VBA

      4:44
    • 1.3: Getting Set up

      7:59
    • 1.4: The Developer Tab

      6:34
    • 1.5: Recording a Macro

      13:55
    • 1.6: Adding Macros to the Quick Access Toolbar

      6:40
    • 1.7: Assigning a Keyboard Shortcut to a Macro

      4:10
    • 1.8: Editing a Recorded Macro

      10:26
    • 1.9 Benefits and Limitations of the Macro Recorder

      9:24
    • 2.1: The Project Explorer

      17:54
    • 2.2: Other Windows in the VBE

      13:44
    • 2.3: Macros and Sub-Procedures

      7:57
    • 2.4: Getting Help

      26:23
    • 2.5: VBE Options

      20:45
    • 2.6: Project Properties

      6:01
    • 3.1: Declaring and Populating Variables

      15:32
    • 3.2: Data Types Part 1

      12:06
    • 3.2: Data Types Part 2

      10:01
    • 3.3: String Variables

      7:38
    • 3.4: Number Variables

      14:28
    • 3.5: Date Variables

      8:02
    • 3.6: Constants

      8:04
    • 3.7: Object Variables

      8:36
    • 4.1: Sub-routines

      11:00
    • 4.2: Functions

      6:06
    • 4.3: Using Arguments

      6:47
    • 4.4: Optional Arguments

      8:46
    • 4.5: Variable Scope

      9:52
    • 5.1: If Statements

      9:09
    • 5.2: Select Case Statements

      9:23
    • 5.3: For ... Next Loops Part 1

      8:06
    • 5.3: For ... Next Loops Part 2

      14:00
    • 5.4: Do Loops

      9:35
    • 5.5: While ... Wend Loops

      15:36
    • 5.6: Array Variables Part 1

      11:29
    • 5.6: Array Variables Part 2

      9:29
    • 5.7: Dynamic Arrays

      12:44
    • 6.1: The Word Object Model

      14:59
    • 6.2: Object Methods

      15:23
    • 6.3: Object Properties

      19:02
    • 6.4: Referring to Objects

      14:15
    • 6.5: Selecting Objects

      11:51
    • 6.6: Testing if and Object Exists

      7:02
    • 6.7: Removing Objects

      9:07
    • 7.1: Events Overview

      14:24
    • 7.2: Document Events Part 1

      12:46
    • 7.2: Document Events Part 2

      12:58
    • 7.3: Using Built-in Dialogs

      18:01
    • 7.4: Creating a User Form Part 1

      14:37
    • 7.4: Creating a User Form Part 2

      10:34
    • 7.5: Event Handlers Part 1

      13:18
    • 7.5: Event Handlers Part 2

      11:33
    • 7.6: Data Validation

      10:18
    • 8.1: Implementing Error Handling

      14:39
    • 8.2: VBA Error Trapping Settings

      6:42
    • 8.3: On Error Resume Next

      8:15
    • 8.4: The Err Object

      11:51
    • 8.5: Monitoring Output

      9:57
    • 8.6: Stepping Through Code

      13:44
    • 8.7: Using Watches

      9:11

About This Class

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.

This course was last updated on November 2015 with the addition of a module aimed at providing further practice by guiding the user, step-by-step, through the creation of an interactive Word VBA solution.

11

Students

--

Projects

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 UK company G Com Solutions Limited provide IT training courses and consultancy to a wide range of UK and international clients. His speciality is running week-long, intensive training workshops on topics like Microsoft Power BI...

See full profile