Excel 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.

You can view this course outline as a PDF for printing

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 0845 485 1173, or email us at sales@computertrainingsolutions.co.uk

Name:* Please enter your name

Company:

Email:* Please enter your email

Telephone:

Contact us for:* Booking Enquiry Information Request

Course interest: Access Dreamweaver Excel Google AdWords Illustrator Indesign Not Listed/Other Outlook Photoshop PowerPoint Project Publisher Word

Message: Please enter your message