Aims

This course takes the user beyond recording a basic macro and introduces the power of VBA, the programming language behind Word. You will be learning basic programming fundamentals, but this is a non-technical course, suitable for Word users at any level.

Objectives

On completion of this course attendees will be able to: Insert and manage a variety of Word fields, including form fields; Record and play back macros; Add macros to command buttons and shortcuts; Understand VBA syntax fundamentals; Use Objects, Properties, Methods and Decision Structures; Interface with the user via input and message boxes; Declare Variables; Perform programme looping and debugging.

Pre-Requistites

Attendees should have working knowledge of Word and have a requirement to automate this work.

Versions

Courses are delivered in 2007, 2010, 2013, 2016.

What will I learn?

Get Started

  • Introduce Visual Basic for Applications
  • Record a macro
  • Run a macro
  • Edit a macro in the Visual Basic editor
  • Understand the development environment
  • Use Visual Basic help
  • Close the Visual Basic editor

Automatic Numbering

  • Define and use bookmarks
  • Predefined bookmarks
  • Select a bookmark in a macro
  • Insert fields
  • View field results or codes
  • Field keys: useful fields
  • Field switches

Work with Procedures and Functions

  • Understand modules
  • Create a standard module
  • Understand procedures
  • Create a sub procedure
  • Call procedures
  • Name procedures
  • Work with the code editor

Use Expressions, Variables and Intrinsic Functions

  • Understand expressions and statements
  • Declare variables
  • Understand data types
  • Work with variable scope
  • Understand constants
  • Use intrinsic constants
  • Use message boxes
  • Use input boxes

Understand Objects

  • Understand objects
  • Navigate the Word object hierarchy
  • Understand collections
  • Use the object browser
  • Work with properties
  • Use the with statement
  • Work with methods
  • Declare and use object variables

Control Program Execution

  • Understand control-of-flow structures
  • Use the if…end if decision structures
  • Use the select case…end select structure
  • Use the Do…Loop structure
  • Use the For…Next structure
  • Use the For Each…Next structure

In-Line Forms

  • Create an on-line form
  • Create a form: form field options
  • Protect forms: save forms data only
  • Print a form
  • Macros and form fields

User Forms and Controls

  • Create User Forms
  • Use the toolbox
  • Work with User Form properties, events and methods
  • Understand controls
  • Set control properties in the properties window

Debug Code

  • Understand errors
  • Use debugging tools
  • Set breakpoints
  • Step through code
  • Use break mode during run mode
  • Determine the value of expressions

How we deliver

Training can be delivered at your offices in either of the following ways:

  • Online

    Online training is ideal if you have staff in different geographical locations who have the same Microsoft or Adobe training requirements.

    Our expert trainers can deliver Watch and Learn sessions to up to 100 people. Alternatively, they can produce an interactive session that allows delegates to complete practical exercises within the Microsoft or Adobe apps of your choosing.

  • Face to face

    Choose from one or half day training sessions or our popular 90-minute Sprint sessions, which can be delivered in your offices or at another location of your choice.

    All we need is a room with a table and chairs and we look after the rest. We can even provide laptops and a projector should you not have spare IT equipment to use.

Sprint learning

Short on time, but still want to boost staff performance?
Book a Sprint Session!

Each Sprint Session follows a 90-minute format for ultra-focused team learning.

Pick a topic, tell us what you want to achieve from your session, and we’ll put together a short, fun, entirely bespoke programme that meets the needs of your team.

Designed to cater for 10-15 delegates at a time

Developed by our team to cover the subject matter of your choice

Delivered online or face-to-face

Stay up to date

Subscribe to our mailing lists:

I would like to receive the following emails:
Mailing lists

We are collecting your email address to send you the emails you select above and we require your consent. By clicking the Subscribe button, we are treating this as your consent. To withdraw your consent, please use the unsubscribe option at the bottom of the received email(s)