Introduction

Introducing Visual Basic for Applications
Defining the development environment
Using help
Closing the VB editor

Developing with Procedures and Functions

Understanding and creating modules
Defining procedures
Creating a sub-procedure
Calling procedures
Utilising the immediate window to call procedures
Making and naming a function procedure
Working using the code editor

Introducing Objects

Defining objects
Examining the Excel object hierarchy
Defining collections
Utilising the object browser
How to work with properties
The with statement
How to work with methods
Building an event procedure

Utilising Intrinsic Functions, Variables and Expressions

Defining expressions and statements
How to declare variables
Determining data types
Programming with variable scope
Harnessing intrinsic functions
Defining constants and using intrinsic constants
Adding message boxes and using input boxes
How to declare and use object variables

Managing Program Execution

Defining control-of-flow structures
Using boolean expressions
Working with the if...end if decision structures
Working with the select case...end select structure
Working with the do...loop structure
Working with the for...next structure
Working with the for each...next structure
Restrictions for use of control-of-flow structures

Harnessing Forms and Controls

Defining UserForms
Utilising the toolbox
Using UserForm properties, events and methods
Understanding controls
Setting control properties in the properties window
Using the label control
Using the text box control
Using the command button control
Using the combo box control
Using the frame control
Using option button controls
Using control appearance
Determining the tab order
Filling a control
Increasing code to controls
How to launch a form in code

Using the PivotTable Object

Defining PivotTables
Making a PivotTable
Using the PivotTable wizard method
Using PivotFields
Adding a procedure to a custom toolbar

Debugging The Code

Defining errors
Working with debugging tools
Determining breakpoints
How to step through code
Working with break mode during run mode
Identifying the value of expressions

Handling Errors

Defining error handling
Defining VBA's error trapping options
Capturing errors with the on error statement
Determining the error object
Coding an error handling routine
Using inline error handling

Training is held in our modern, comfortable, air-conditioned suites

Modern-spec IT, fully networked with internet access

"What do I get on the day?"

Learning tools

Breaks and timing

Courses start at 9:30am.
Please aim to be with us for 9:15am.
Joining information (how to get to our venues)

In-course handbook

Contains unit objectives, exercises and space to write notes

Refreshments

Available throughout the day:

• Hot beverages
• Clean, filtered water
• Biscuits

Reference material

Available online. 100+ pages with step-by-step instructions

Lunch

Lunch is provided at a local restaurant or pub. Browse the sample menus:

• Bloomsbury
• Limehouse
• Southwark

24 months access to Microsoft trainers

Your questions answered by Microsoft qualified trainers online.

• 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
• Consultancy