excel VBA programming course

This is a course for Excel developers who want an appreciation of the Excel version of VBA (Visual Basic for Applications) and its use in enhancing spreadsheet operability.

It will suit anyone who has been recording macros and now wants to gain more control over automation of their spreadsheets than recording alone provides.

course duration

Two days on-site.

course pre-requisites

Skills in using Excel to a level that would be achieved by completing our Intermediate and Advanced Excel training courses.

course content

Topics may include the following and you can specify others to suit your objectives.

recording macros

Why and when to record
Editing recorded macros

excel VBA

Using the Visual Basic Editor
VBA syntax
VBA help
Projects
Modules
Objects and object hierarchy.

procedures and functions

Sub procedures
Function procedures
Calling procedures
Use of Immediate Window to test code
Organizing code and procedures.

references

Relevance of references
Managing References.

working on properties

Distinguishing Properties
Influencing properties
Using With...End With statements.

working with methods

Distinguishing Methods
Applying methods.

coding

Expressions
Statements.

variables and constants

Declaring variables
Variable data types
Variable scope and lifetime
Local and global constants.

functions

Creating a function
Using a function

capturing user input

Message boxes
Input boxes
Custom dialog boxes.

program execution control

Program flow
Boolean expressions
If...Else...End statements
Select Case...End Select statements
For...Next statements
For Each...Next statements
Do...Loop statements.

range object

Addressing cells
The active cell
Range offsets
Doing things to cells
Doing things with cells.

worksheets and workbooks

Addressing worksheets
Addressing workbooks.

toolbars

Creating toolbars using VBA.

debugging code

Understanding Errors
Using debugging tools
Testing and evaluating expressions.

error handling

Purpose of error handling
Essential error handling
VBA error object
Trapping and responding to errors
General-purpose error-handling code.

london, kent, surrey and sussex

We regularly travel to clients in London and the South East. Based near Tonbridge, we are particularly well placed to visit clients throughout Kent, East and West Sussex, Surrey and London.

As we have done in Ashford, Aylesford, Brighton, Canterbury, Chatham, Chiddingstone, East Grinstead, Edenbridge, Heathfield, Lightwater, London, Maidstone, Maresfield, Orpington, Paddock Wood, Richmond, Rochester, Sevenoaks, Sittingbourne, Tadworth, Ticehurst, Tonbridge, Tunbridge Wells and Westerham.