Record and run macros using the Developer tab
Accountants
Average UK salary £25,000 - £60,000
View career guideMicrosoft Excel VBA Course
Microsoft Excel VBA Course
Microsoft Excel VBA Course
This VBA and Excel course will unlock the power of coding in Excel. Learn how to create dynamic macros to automate repetitive tasks, streamline data processing, and enhance productivity.
Dive into the world of Visual Basic for Applications (VBA) and gain the skills to write custom code that extend Excel's functionality. Discover the art of coding with VBA as you build interactive applications, manipulate data, and control Excel objects.
This course will equip you with the knowledge and tools to harness the full potential of VBA in Excel.
Key Learning Points
Key Learning Points
- Record and run macros using the Developer tab
- Work in the Visual Basic Editor confidently
- Use variables, loops and control-of-flow structures
- Work programmatically with ranges and worksheets
- Build interactive user forms with form controls
If attending an online course you must have a licensed copy of any software required and access to a suitable computer.
You'll need to have attended our Excel Advanced course or have equivalent working knowledge before joining this class.
Who is this course for?
For experienced Excel users who want to automate tasks and build custom tools using VBA macros. Requires our Excel Advanced course or equivalent working knowledge.
Expert Trainers
Course leader is an experienced industry expert
Private & team training.
This course is not on our public schedule at the moment. You can still request a bespoke quote below — we’ll contact you with dates and pricing.
Course Dates
Course Outline
1
Getting Started
Displaying the Developer Tab
Recording and running a Macro
Macro-Enabled Workbooks
Using the Visual Basic Editor
The Development Environment
Understanding Macro Security
2
Working with Procedures and Functions
Understanding Modules
Understanding Procedures
Calling Procedures
Creating a Function Procedure
Working with the Code Editor
3
Understanding Objects
Objects and Collections
Working with Properties
Using the With Statement
Creating an Event Procedure
4
Using Expressions, Variables, and Intrinsic Functions
Understanding Expressions and Statements
Declaring Variables
Understanding Data Types
Using Intrinsic Functions
Understanding Constants
Declaring and using Object Variables
5
Controlling Program Execution
Control-of-Flow Structures
Working with Boolean Expressions
Different types of Control-of-Flow structures
Guidelines for use of Control-of-Flow Structures
6
Working with Forms and Controls
Working with UserForm Properties, Events and Methods
Working with different Controls
SettingControl Appearance
Populating a Control
Adding Code to Controls
Launching a Form in Code
7
Handling Errors
Understanding Error Handling
Writing an Error-Handling Routine
Working with Inline Error Handling
8
Questions and answers
This course is only available as a private course. This allows you to choose the dates for your training. And, if you wish, we can tailor the content for you or your team. Please contact us for more details.
Career paths
Roles this course supports
People training on Microsoft Excel VBA often work in the careers below.
Who attends?
Career Progressives
Professionals who wish to develop skills for their current role and companies who believe in developing their talent.
Career Changers
People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.
Graduates
Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.
Learn Your Way
Face To Face
Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.
Live Online
Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.
Team Training
Upskill your team together. Build your team and develop consistency, and collective confidence.
Three Steps To Success
1
Identify Your Path
Define your direction with purpose, aligning your learning journey to personal and career goals.
2
Learn With Experts
Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.
3
Earn Certification
Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.
Related Courses
Power BI Business Analytics
Turn raw data into clear, interactive dashboards and reports with Power BI. A two-day…
From £599 + VAT
Microsoft Powerpoint Adv
Create high-impact presentations with advanced PowerPoint techniques on this one-day…
From £249 + VAT
Microsoft Powerpoint Intro
Create professional, engaging presentations in Microsoft PowerPoint on this one-day…
From £249 + VAT
Further Reading
Why You Should Learn Microsoft Power BI?
Microsoft Power BI turns raw data into clear, actionable insights. Find out what it can do, how businesses use it and…
How Learning Power BI can help your Career
Power BI is one of the most in-demand data skills in business. Find out what it can do, who uses it and how learning…
8 Tips To Make You An Excel Expert
Learning Excel is always useful whether you work with data or in finance. Here are 8 tips to help you master…