VBA Programming Training London and UK-wide

London's widest choice in
dates, venues, and prices

Training formats & services

On a public schedule at one of our
London training venues.
On-site at your company office UK wide
Near-site, at a location close to you
Tailored courses to your requirements

Promotions

Training is available in one of our 6 London centres, on-site or tailored training courses

How to Book :: Training Schedule :: Contact Us

Introduction to VBA Programming for Microsoft office Applications

Duration: 2 days
Level: VBA
Suitable for: Students taking this course should be familiar with personal computers and Microsoft Office 2000
Platform: PC

For more information on VBA training please see our new main page: VBA Training London and UK

Syllabus includes:

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