Got a question? Call 1800 853 276   |   

Word 2016 – Programming in VBA

  • Length 2 days
  • Price $880 inc GST
Course overview
View dates &
book now
  • Register interest

Why study this course

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

This course builds on the introductory skills of Level 1. You may also be interested in our Level 2 and Level 3 courses which cover more advanced topics.

Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.


What you’ll learn

At the completion of this course you should be able to:

  • Understand the Word object model and VBA concepts

  • Work effectively with the main features of the VBA Editor window

  • Create procedures in VBA

  • Create and use variables

  • Create and work with user-defined functions

  • Use programming techniques to control the action taken by your program

  • Construct loops that repeat code according to different requirements

  • Identify and select specific text using code modules

  • Create and use code to undertake basic file management tasks

  • Create code to drive a user form

  • Write a variety of error handling routines

  • Use VBA code to display and use Word’s built-in dialog boxes


Microsoft Office Applications at DDLS

DDLS is your best choice for training and certification in any of Microsoft’s leading technologies and services. We’ve been delivering effective training across all Microsoft products for over 30 years, and are proud to be Australia’s First and largest Microsoft Gold Learning Solutions Partner. All DDLS Microsoft courses follow Microsoft Official Curriculum (MOC) and are led by Microsoft Certified Trainers. Join more than 5,000 students who attend our quality Microsoft courses every year.


Stay ahead of the technology curve

Don’t let your tech outpace the skills of your people

Quality instructors and content

Expert instructors with real world experience and the latest vendor- approved in-depth course content.

Partner-Preferred Supplier

Chosen and awarded by the world’s leading vendors as preferred training partner.

Ahead of the technology curve

No matter your chosen technologies or platforms, we can help you stay one step ahead.

Who is the course for?

This course is designed for people who wish to learn how to use the inbuilt VBA programming language in Microsoft Word 2016 to enhance their documents and automate processes.

We can also deliver and customise this training course for your organisation. For more information, please contact us on 1800 853 276.


Course subjects

Understanding 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 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

  • 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

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

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

  • 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

  • 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

  • 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

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

  • 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

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

  • 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


Prerequisites

This course assumes a good working knowledge of Word 2016. The learner should be able to create and edit different kinds of documents and must also have a general understanding of personal computers and the Windows operating system environment and be able to use File Explorer to locate and copy files.


Terms & Conditions

The supply of this course by DDLS is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.



Request Course Information

By submitting an enquiry, you agree to our privacy policy and receiving email and other forms of communication from us. You can opt-out at any time.