0345 4506120

Microsoft Office - VBA Advanced

Course Details

Name Microsoft Office - VBA Advanced
Start Date:
Working Days:
£199.00 +vat
Course ID:


This course covers 2007, 2010, 2013 and 2016 versions

This is a one-day training course structured into 6 modules
Course Aims:
This intensive, hands-on one-day course has been designed to build on the foundation created in the VBA Introduction course, to increase their capability to automate and enhance their Excel spreadsheets by the use of advanced tools and concepts.
Target Audience:

This is a course which naturally follows on from the Introduction course. Delegates must either have attended the Introduction course or be fully conversant with all its subject matter.

About Microsoft VBA:

VBA stands for Visual Basic for Applications and is a programming language developed by Microsoft. Although VBA is derived from the programming language Visual Basic, it is normally used within a host application (e.g. Excel, Access, etc.) not as a standalone language.

Class Sizes:

Maximum class size for Microsoft Excel courses is 6 delegates, which ensures that attendees get adequate time for personal attention from the instructor.

Course Content

MODULE 1:  Advanced Procedures
Learning outcomes:
Explore the more advanced options of sub and function procedures to create more flexible programs
Topics covered:
  • Calling Procedures
  • Passing Values to Procedures
MODULE 2:  Advanced Variables
Learning outcomes:
Introduce advanced variable types to store data arrays and simplify the control of objects
Topics covered:
  • Understanding Variable Scope
  • Understanding Object Variables
  • Creating Array Variables
  • Creating Dynamic Array Variables
MODULE 3:  Interacting with Office Applications
Learning outcomes:
Gain an introduction into the use of VBA to control other office applications to create letters and presentations
Topics covered:
  • Setting References to other Applications
  • Setting References using Late Binding
  • Create a PowerPoint Presentation
  • Create a Letter in Word
MODULE 4:  Debugging and Error Traps
Learning outcomes:
Using VBA's debugging tools to find and correct errors in code, react to un-foreseen problems
Topics covered:
  • Review of Error Types
  • Debugging tools
  • Setting Error Traps
MODULE 5:  Creating Custom User Forms
Learning outcomes:
Use the VBA editor to create custom forms and controls, to gather and validate information from the user
Topics covered:
  • Creating a Custom Form
  • Adding Form Controls
  • Creating Event Procedures
MODULE 6:  Workbook and Worksheet Events
Learning outcomes:
Explore the use of Workbook and Worksheet events to react to the users actions and help control your application
Topics covered:
  • Create Workbook Events
  • Create WorkSheet Events

Leeds - West One


Our training facilities in Leeds are located centrally in state of the art premises at the West One office building. Our training rooms are spacious, air-conditioned and fully-equipped, and provide a fantastic environment for your training. The location is just a three-minute walk from Leeds Rail Station, straight along Wellington Street.

Note: We no longer provide complementary lunches for delegates, though free tea/coffee are available in morning and afternoon breaks.


100-114 Wellington Street



By Car

There are a number of local car parks, all within a 10 minute walk of the centre. These can be found as follows: LS1 4AJ Wellington Place (NCP) LS1 4LT Wellington Street Multi Storey LS1 4PH Castle Street car park LS1 4PH International Pool, Westgate

By Train and Bus

Leeds Rail Station is the main terminus for rail travel to Leeds, providing links to the whole of the UK. Buses travel from all areas of Leeds to Leeds Rail Station. When leaving the station, take the left hand exit, past the ticket counter and food outlets out on to the street. Cross the road and walk straight ahead for 20 yards into Wellington Street. Turn left and proceed for 450 yards: West One (100-114) is on the right hand side. Using the main entrance takes longer: you will need to turn left into New Station Street and proceed 100 yards until you get to the Queens Hotel. Turn left and make sure to cross the road so you stay on Wellington Street. Keep walking for 550 yards: West One (100-114) is on the right hand side.

Every delegate on a Microsoft Excel course also gets a Training Attendance Certificate.

With every Microsoft Excel training course, you get a free workbook as well as downloadable exercises, which match the course content exactly, so you can review and revise afterwards to reinforce your knowledge.

Our Customers Include