Microsoft Word VBA Course (Sydney)

Microsoft Word VBA Course

View, edit, and create beautiful documents with our Microsoft Word courses in Sydney.

Microsoft Word allows you to create, edit, and share work quickly and easily. Learn Microsoft Word with our Microsoft Word courses in Sydney.

The skills and knowledge acquired in this Microsoft Word VBA course are sufficient to be able to create real life working VBA applications within Word. You will be able to work with VBA within the Word environment to program and automate document operations.

Learning Outcomes

At the completion of this Microsoft Word VBA training course you should be able to:

  1. Understand the Word object model and VBA concepts.
  2. Work effectively with the main features of the VBA Editor window.
  3. Create procedures in VBA.
  4. Create and use variables.
  5. Create and work with user-defined functions.
  6. Use programming techniques to control the action taken by your program.
  7. Construct loops that repeat code according to different requirements.
  8. Identify and select specific text using code modules.
  9. Create and use code to undertake basic file management tasks.
  10. Create code to drive a user form.
  11. Write a variety of error handling routines.
  12. Use VBA code to display and use Word’s built-in dialog boxes.

Course Content

The following content will be covered in this Microsoft Word VBA training course:

Understanding Microsoft Word VBA

  • Programming in Microsoft Word.
  • VBA Terminology.
  • Displaying the Developer Tab.
  • The VBA Editor Screen.
  • Opening and Closing the Editor.
  • Understanding Objects.
  • The Object Hierarchy.
  • Viewing the Word Object Model.
  • Using the Immediate Window.
  • Working With Object Collections.
  • Setting Property Values.
  • Using the Object Browser.
  • Programming With the Object Browser.
  • Accessing Help.
  • Code Glossary.

Starting With Microsoft Word VBA

  • Using the Project Explorer.
  • Using the Properties Window.
  • Using the Work Area.
  • Viewing Other Panes.
  • Working With Toolbars.
  • Working With a Code Module.
  • Running Code From the Editor.
  • Setting Breakpoints in Code.
  • Stepping Through Code.

Procedures in Microsoft Word VBA

  • Understanding Procedures.
  • Where to Write Procedures.
  • Creating a New Sub Routine.
  • Using IntelliSense.
  • Using the Edit Toolbar.
  • Commenting Statements.
  • Indenting Code.
  • Bookmarking in Procedures.
  • Code Glossary.

Microsoft Word VBA Variables

  • Understanding Variables.
  • Creating and Using Variables.
  • Explicit Declarations.
  • The Scope of Variables.
  • Procedure Level Scoping.
  • Module Level Scoping.
  • Understanding Passing Variables.
  • Passing Variables by Reference.
  • Passing Variables by Value.
  • Understanding Data Types for Variables.
  • Declaring Data Types.
  • Using Arrays.
  • Code Glossary.

Microsoft Word VBA Functions

  • Understanding Functions.
  • Creating and Calling Functions.
  • The MsgBox Function.
  • Using MsgBox.
  • The InputBox Function.
  • Using the InputBox Function.
  • Nesting Functions.
  • Using Functions in Function Procedures.
  • Code Glossary.

Decision Structures in Microsoft Word VBA

  • The IF Statement.
  • Using IF for Single Conditions.
  • Using IF for Multiple Conditions.
  • The Select Case Statement.
  • Using the Select Case Statement.
  • Using Select for Sets of Values.
  • Using Select for Ranges of Values.
  • Code Glossary.

Looping Structures in Microsoft Word VBA

  • For Loops.
  • Looping With Specified Iterations.
  • Looping for Each Item.
  • Adding an Exit to a Loop.
  • The Do Loop Statement.
  • Looping With Unknown Iterations.
  • Code Glossary.

Working With Text in Microsoft Word VBA

  • Understanding Text and Document Components.
  • Understanding the Story Range.
  • Understanding the Selection Object.
  • Using the Selection Object.
  • Understanding the Range Object.
  • Using Range Objects.
  • Assignment – Inserting Text.
  • Code – Inserting Text.
  • Assignment – Displaying Text in a Text Box.
  • Code – Displaying Text in a Text Box.
  • Understanding the Find Object.
  • Assignment – Performing a Find Operation.
  • Code – Performing a Find Operation.
  • Code Glossary.

Microsoft Word VBA Document Management

  • The Activate Open and Close Methods.
  • Opening and Closing Documents.
  • Understanding the Add Method.
  • Understanding the Save Methods.
  • Assignment – Creating and Saving Documents.
  • Code – Creating and Saving Documents.
  • Properties That Return Information.
  • Functions That Return Information.
  • Assignment – Getting Information.
  • Code – Getting Information.
  • Understanding Files Folders and Drives.
  • Working With Files and Folders.
  • Assignment – Displaying Files in a UserForm.
  • Code – Displaying Files in a UserForm.
  • Removing Files and Folders.
  • The Application and Options Object.
  • Code Glossary.

Programming UserForms in Microsoft Word VBA

  • Handling Form Events.
  • Initialising a Form.
  • Closing a Form.
  • Creating Functions for a Form.
  • Creating Code for Option Buttons.
  • Assignment – Using the AfterUpdate Event.
  • Code – Using the AfterUpdate Event.
  • Setting Bookmarks for Data Entry.
  • Assignment – Using Bookmarks to Enter Data.
  • Code – Using Bookmarks to Enter Data.
  • Setting the Tab Order.
  • Forcing Correct Entry.
  • Templates and AutoStart Macros.
  • Creating a Template With AutoMacros.
  • Code Glossary.

Microsoft Word VBA Error Handling

  • Understanding Error Types.
  • The on Error Statement.
  • Simple Error Trapping.
  • Using the Resume Statement.
  • Using Decision Structures in Error Handlers.
  • Assignment – Using the Err Object.
  • Code – Using the Err Object.
  • Assignment – Error Handling in Event Procedures.
  • Code – Error Handling in Event Procedures.
  • Defining Custom Errors.
  • Code Glossary.

BuiltIn Dialogs in Microsoft Word VBA

  • The Dialogs Collection.
  • Dialog Box Arguments.
  • Using the Execute Method.
  • Using the Show Method.
  • The Display Method.
  • Using the Display Method.
  • Working With Dialog Tabs.
  • Assignment – Using Dialogs With a UserForm.
  • Code – Using Dialogs With a UserForm.

Intended Audience

This Microsoft Word VBA training course provides a comprehensive and thorough coverage of the topics outlined above and is ideal for anyone who is looking to program and automate document operations in Microsoft Word. This Microsoft Word course is ideal for anyone who has completed Microsoft Word Course: Level 3 and is seeking to create VBA applications within Word.

Delivery Style

This Microsoft Word VBA course is presented as a practical, instructor-led computer-based training course in a Microsoft Windows environment. In this Microsoft Word course you’ll have dedicated access to a computer exclusively for your use so you can follow instructor training and work through examples in an application-focused teaching environment.

Course Prerequisites

This Microsoft Word VBA course assumes that you have a good working knowledge of Microsoft Word. You should be familiar with the basic functions of a computer operating system such as navigating the environment using a mouse and keyboard, starting applications, copying and pasting objects, formatting text, creating folders, opening files, saving files, familiarity with the accessing the Internet and use of common web browsers. If you do not have these skills, we recommend attending the Basic Computer Skills Course before attempting this course.

Globe

TOP 1%

universities in the world*

Student

13 in top 200

13 UON disciplines ranked in top 200 in the world*

Stars

5 Stars

Good Universities Guide*

Course Features

Available dates for Microsoft Word VBA Course

This course has no dates available. Be the first to know when we schedule more. Get notified.