Excel VBA Training Course

This two-day Microsoft Excel VBA course takes you through Visual Basic for Applications in Excel from recording macros through to advanced form design. On the way you will learn how to write object-oriented programs and how to create loops and implement error-handling.

You should be an advanced user of Excel and ideally have attended Intermediate and Advanced level courses before attending this training.

Premier Training also offer Excel consultancy services.

Automating Everyday Tasks
How Visual Basic for Applications talks to Microsoft Excel
Creating a simple macro
Recording and editing macros
Stepping through a macro
Relative and absolute recording
Assembling a project from multiple macros.

Introduction to VBA
Recording a macro in Excel
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

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
Comboboxes (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)
Event triggered procedures
Creating add-in applications
Links to other applications

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

Premier's London Training Centre
42 New Broad Street, EC2

How to find us

Premier's most popular courses:

SharePoint 2007 Power User
Microsoft Project Training
Prince2 Practitioner
Excel VBA Training
Sharepoint Designer
Visio Flowcharting