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.
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS you get more courses, more often, in more locations and from more vendors.
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.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS you get more courses, more often, in more locations and from more vendors.
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.
Train Anywhere
From our state-of-the-art classrooms to telepresence to your offices, our instructor-led training caters to your needs.
Track Record
30 years driving innovative, award-winning learning solutions
More Courses, More Often
When you train with DDLS you get more courses, more often, in more locations and from more vendors.
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 larger groups – saving your organisation time, money and resources. For more information, please contact us via email on ph.training@ddls.com.ph
.
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.
