Microsoft Word VBA Training Course

This course is designed for experienced Word users. Knowledge of other programming languages is useful but not essential. This course will help you build complex templates and automate routine tasks.

Overview of Visual Basic
Objects and hierarchies
Introduction to VBA
Recording a macro
Running a macro
Editing a macro

Overview of Visual Basic Editor
Creating modules
Project window
Properties window

Inputs and Outputs
Selecting cells, ranges and objects
Entering formulas and calculations
Input and message boxes

Variables
Assigning data to variables
Declaring variables
Data types
Variable scope
Constants
Using option explicit

Custom Dialog Boxes
Dialog boxes for data input

Control Structures
If, then, select case, do, while, for and for each

Objects, Properties, methods, events and error handling
Capturing errors
Manipulating errors

Debugging
Quick watch (for variables)
Break points
Debug window

Forms (dialog boxes)
Command buttons
Combo boxes (dropdowns)
Tick boxes
Radio buttons
Form initialisation

Menus and toolbars
Building custom menus
Modifying the standard toolbars
Creating custom tools & toolbars

Optional Extras (if required)
Links to other applications

4 Ravey Street
London EC2A 4QP
t: +44(0)20 7729 1811
f:+44(0)20 7729 9412
information@premiercs.co.uk