Download our guide to end user applications

VBA for Microsoft Excel (VBAE)

Length 2 days
Price NZD 1390 exc GST

Course overview

View dates &
book now

Why study this course

This course aims to cover in detail the Visual Basic for Applications (VBA) programming language, and in particular using it with Microsoft Excel.

VBA is effective and efficient for automating repetitive tasks, prompting user action, interacting between Office applications, and finding alternative solutions to various problems.

You'll learn how to program in VBA in order to customise your work environment in Excel. You'll learn to understand programming terminology such as modules, procedures, variables, and constants. You'll learn form design, control structures, and how to debug and test your VBA application before using it in the work environment.

Request Course Information

What you’ll learn

After completing this course, students will be able to:

Understand Templates and Macros
Look at the Visual Basic editor
Record a Macro
Design Forms
Write code
Understand Procedures
Use Variables and Constants
Understand Properties, Methods, Events, and Objects
Understand the Range Object (in Excel)
Use control structures
Use debugging and error-trapping

Microsoft Apps at Lumify Work

As part of Lumify Group, Lumify Work has skilled more people in Microsoft technologies than any other organisation in Australia and New Zealand. We have a campus in the Philippines, too. We offer the broadest range of instructor-led training courses, from end user to architect level. We are proud to be the winner of the Microsoft MCT Superstars Award for FY24, which formally recognises us as having the highest quality Microsoft Certified Trainers in ANZ.

View all Microsoft Apps at Lumify Work courses

Who is the course for?

This course is intended for those wanting to utilise VBA to enhance their use of Microsoft Excel.

Course subjects

Understanding Templates and Macros

Workbook projects
Template projects
Using the Personal.xls in Excel
The project explorer
The code window
The toolbox
The properties window
Looking at the code created by the recorder

Controls - Command Buttons, Textboxes, and Labels

Setting control properties
Assigning code to respond to controls and click events
Creating an event procedure

How Code is Stored

Modules
Forms
Using comments

Writing Code That is Easy to Read and Navigate

Sub procedures
Function procedures
Public procedures
Private procedure

Data Types

Declaring a variable or constant
Using built in constants

Understanding Properties, Methods, Events, and Objects

Using With…End With to set multiple property values for a single object

Understanding the Range Object (in Excel)

Using cell addresses as range references
Relative referencing
Using the Offset property

Control Structures

Decision structures
- If... Then
- If…Then…Else
- If…Then... Elseif
Select Case
Looping Structures
- Do…Loop
- Do While…Loop
- Do Until…Loop
- Do…Loop While
- Do…Loop Until
- For…Next
- For Each…Next

How to Handle Errors

Designing an error handler
Using Break Mode
Using the Debugging window
Avoiding bugs

Prerequisites

This course requires an advanced knowledge of Microsoft Excel. We recommend attending our Excel - Advanced course prior to this one, or that you possess the equivalent knowledge and skills.

Terms & Conditions

The supply of this course by Lumify Work is governed by the booking terms and conditions. Please read the terms and conditions carefully before enrolling in this course, as enrolment in the course is conditional on acceptance of these terms and conditions.

Request Course Information

Looking for more course options?

View all Microsoft Apps courses View all End User Applications courses View all Application and Web Development courses

Offers

Accelerate Copilot adoption with up to 50% off training

The promise of AI and Microsoft 365 Copilot in particular is clear. Microsoft research demonstrates that Copilot adoption results in: Significant time savings across departments Improved efficiency in document creation and communication Enhanced employee satisfaction and reduced repetitive tasks Copilot boosts creativity and makes data-driven insights more accessible than ever before. But how can businesses realise these benefits at scale? As the 2024 Work Trend Annual Report noted: “We’ve come to the hard part of any tech disruption: moving past experimentation to business transformation. Just as we saw with the advent of the internet or the PC, business transformation comes with broad adoption.” Training drives effective AI adoption Key findings of a recent Australian Government trial of Microsoft 365 Copilot highlight the importance of AI skilling: Capability challenges were a key barrier to adoption; participants needed both tailored training that provided agency-specific use cases and general generative AI training in prompt engineering. 75% of participants who received three or more forms of training were confident in their ability to use Copilot -- 28 points higher than those who received just one form of training. Training enhanced confidence in Copilot use and was most effective when tailored to an agency’s specific context. Identifying specific use cases for Copilot could lead to greater use of Copilot. Lumify is here to help Setting up a Copilot trial? Rolling out this incredible technology across your business or within a specific team? Talk to us! We can design a tailored training plan for you. Unlock the offer code by 30 September 2025 and access these limited-time discounts: 50% off private, customised training for 10 or more students 25% off seats on our publicly scheduled training courses Terms and Conditions Offers valid only on Microsoft Authorised courses booked by 30 September 2025 and delivered by 31 December 2025. To redeem, the customer must unlock the code on the offer page and mention this to their Lumify Work Account Manager or a customer service representative during booking. Not applicable in conjunction with any other Lumify Work special offers or packages. All other standard Lumify Work Terms and Conditions apply. Lumify Work reserves the right to modify or terminate this promotion at any time.

Find out more