Excel Macros and VBA Course Outline

0800 019 6882

	Excel 2003 - Macros and Introduction to VBA (1 day course)

This one day Excel VBA course can be booked according to our course schedule, or alternatively you can book a trainer to visit you. Contact us for more details!

Please note we can tailor this VBA 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

If you would like to make an enquiry about our Training, fill in the form below, or call us on 0800 019 6882, or email us at sales@computertrainingsolutions.co.uk