Who is this course for?
This course has been developed for advanced Word users who need to automate document handling using Word Visual Basic for Applications (VBA).
How long is this course?
What do I need to know before attending?
Competence with Microsoft Windows. Familiarity with many of the features covered on the Introductory and Advanced Word courses.
What will I expect to achieve at the end of the training?
At the end of this course
you will be able to:
- Appreciate the benefits of using Visual Basic (VBA) macros.
- Record, run and edit basic Word macros.
- Interpret and edit VBA code.
- Apply programming techniques such as conditional branching and loops to your macros.
- Acquisit user data and display messages.
- Create User Forms to manage complex user input.
Overview of the uses of document Templates and the features that are stored within them.
Creating and editing Templates, and copying features from one Template to another.
An introduction to creating and editing forms as a means of controlling the positioning and contents of entries made to standard layout documents.
VBA (Macro) Basics
Recording simple Macros to automate routines such as document formatting.
Using convenient ways of running Macros - toolbars, buttons within documents, shortcut keys.
Editing VBA Program Code
An introduction to the programming behind recorded Macros.
Understanding the syntax of the code and making simple changes.
Using the VBA Help system.
Introducing some commonly used commands to give more power and flexibility to your Macros, such as making the actions of your Macro conditional on some activity.
Creating non-recordable code for:
Managing user-input and displaying messages.
Declaring and using variables.
Use of conditional statements.
Looping and using sub-routines.
Creating and utilising custom User Forms to manage user interaction.
Processing data returned from user forms.
Other topics of interest will be covered when you are comfortable with the core elements of the course, where time allows.