VBA Programming Training London and UK-wide

Introducing the Visual Basic Editor
Using the Visual Basic Editor

Working with the Object Model
Using the Object Model

Working with the object variables
Creating and using object variables

Working with string variables
Using string variables

Working with date variables
Discussing and using date variables

Working with numeric variables
Discussing and using numeric variables

Using the selection structure
Discussing and using the selection structure

Using the Select Case statement and the MsgBox function
Understanding and using Select Case statement and MsgBox function

Working with the repetition structure and the With statement
Understanding and using the repetition structure and the With statement

Advanced repetition structure and string functions
Using the string repetition structure and string functions

Working with built-in dialog boxes and the Office Assistant
Communicating with the user
Using built-in dialog boxes and the Office Assistant

Working with custom dialog boxes
Creating custom dialog boxes

Working with option button, check box, and list box controls
Discussing the dialog box controls
Using the option button, check box, and list box

Automation
Understanding and using the Automation process

Advanced Automation and error trapping
Discussing and using Automation and error trapping