Great Shelford, Cambridge / Online
2 day course
£495.00 (ex. VAT)

This extensive 2 day course focuses on providing you with a wide general knowledge of Excel Visual Basic for Applications Programming, from the essentials to more advanced techniques. While attendees may have an initial grasp or knowledge of VBA, this course will introduce the basics as well as cover many of the advanced techniques used within VBA. 

This is a fast-paced course aimed at getting you comfortable using VBA, from understanding the visual basic editor to creating user defined functions and various debugging techniques.

Those who attend this course will need to be experienced, competent and confident advanced Excel users and may have previously attended our Advanced Formulae and Functions as well as our Validate and Summarise courses.

Course Outline

What is Visual Basic for Applications?

  • An Introduction to Macros
  • Recording Macros
  • Running Macros

Understanding the Visual Basic Environment

  • The Visual Basic Editor
  • Understanding the syntax of your Macros
  • Editing Macros
  • Adding comments and documentation to your macros
  • Assigning VBA and Macros to keyboard shortcuts, icons and menus

With Statements

 

Managing Error Messages

 

Debugging Techniques

 

Working with Variables and Data Types

 

User Defined Functions

 

Understand Objects and Collections

 

Add conditions to your macros

 

Communicate with the user

  • Message boxes
  • Input Boxes
  • Working with return values

Repeating Actions in VBA – Loops

  • Fixed loops
  • Flexible Loops

Customise Menus and Toolbars

 

Automation with Macros

  • Create Custom Dialog Boxes

Book This Course

Public Course Dates

This course is taught at our training centre in Cambridge.  Check our current available dates for this course below and register your place. Please note that payment is not made by the booking form below – Instead, you will be sent an invoice with instructions on how to pay and confirm your place shortly afterwards.

Company Group Training

We also provide group training for companies on dates that work for them. This can be done via our training centre, on-site or virtually. Please submit your details here for more information.

Online Training

This course is also taught virtually. To enquire about virtual remote training please submit your details here.

Related Courses

Microsoft Excel Introduction

Microsoft Excel Intermediate

Microsoft Excel Advanced Formulae & Functions

Microsoft Excel Advanced Validate & Summarise

Microsoft Excel Dashboards Made Easy

Microsoft Excel Expert Formulae

Microsoft Excel Power Pivot and Power Query

Microsoft Excel VBA