Please note we can tailor this course to suit your needs, for example we can include Access VBA, Word VBA etc.  We can hold this course onsite at your premises or we can source a suitable meeting room.

Course objectives:

By the end of this course you should be confident to create procedures for controlling the behaviour and appearance of an Excel spreadsheet, create procedures that run in response to specific events, create user forms to accept or display data, validate the data entry in user forms, and debug and handle errors in code.

Prerequisites:

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

Course contents

VBA terminology

• Start the VBA editor

• Work with:

  - Object properties

  - Methods

• Attach code to events and buttons

• Use the object browser

Programming basics

• Variables and data types

• Expressions

• Manipulating data

• Getting input from the user in Input and Message boxes

• Variables and scope

• Procedures

• Calling one procedure from another

Using loops

• Do / while

• For / Next

• If...Else..End..If

• Select Case...Case 1,2,3, Else...End Else

USER FORMS

• Creating a dialog box (user form)

• Displaying a dialog box

• Using text boxes and labels

• Using command buttons

• Using combo and list boxes

  Error handling

• Identifying compile-time, run-time and logical errors in code

• Use the debugging tools

• Write error handling code to trap errors

Register for our newsletter to receive details of current special offers!

Providing training throughout England and Wales including:

Excel VBA, Access VBA, VBA training, VBA course, VBA training provider, VBA training provider Bristol, Bath, Dorset, South West, Devon, Cornwall, Somerset, Gloucestershire, London and many more