Microsoft Excel VBA Course

Automate Excel tasks and build powerful custom tools using VBA on this two-day practical course.

Covering macros, the Visual Basic Editor, loops, error handling and interactive user forms.

Reviews

9.8

Satisfaction

100.0%

Recommend

See Reviews

Microsoft Excel VBA Course

Name: Microsoft Excel VBA
Rating: 4.9 (68 reviews)

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.

This course requires solid Excel foundations — our Microsoft Excel Introduction and Microsoft Excel Advanced courses are the recommended starting points.

Two Days

10:00 - 16:30 UK Time

Private Options

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

Class Size

1 - 10 in person or 1 - 6 online

Support

28 days free helpdesk support with all courses

Cancellation

Cancel before 7 days for 100% refund

Certificate

Earn a certificate of attendance on completion

Volume Discounts

Save money by using our Learning Pots scheme

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.

Request a quote for Microsoft Excel : VBA

This course is offered as private, bespoke or team training at our centre, live online or at your venue.

You can customise the outline, have a group where it's just your team or enjoy a one-to-one session with an expert.

Fill in the form below and our team will get in touch with pricing and helpful advice.

Course Dates

Course Outline

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

Working with Procedures and Functions

Understanding Modules

Understanding Procedures

Calling Procedures

Creating a Function Procedure

Working with the Code Editor

Understanding Objects

Objects and Collections

Working with Properties

Using the With Statement

Creating an Event Procedure

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

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

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

Handling Errors

Understanding Error Handling

Writing an Error-Handling Routine

Working with Inline Error Handling

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.

Really thorough and could relate to struggles and correct some errors made

Very interactive & trainer tailored the course to suit our needs

Tom was fantastic, he tailored the course to suit what we were looking for meaning we will be able to use this in our day to day lives and make our j…

Really very thorough, very approachable and an enjoyable course

Very thorough referencing and alternative working options

Very interactive learning style, tutor is clearly very knowledgeable & friendly

Very relaxed tutor, calm and concise when correcting errors made by delegates, Me!

Loved the way the course was taught, by taking us through each step but getting us to do it at the same time, such an easy way to learn and helped ma…

Great at explaining with relevant examples. Great at responsive learning and getting the group involved in problem solving.

Loved the teaching style Rob had, it really worked well for the training

I learned a lot, not just about the using VBA, but on methods to problem solve on my own. Really enjoyed the course

Great course, covered solid basics and happy to answer questions even if not 100% relevant which was great and helped shape the day and tailor to our…

Everything. Very clear and well explained

Course/ trainer was really informative - made sure we were all following along and understanding the topics as well as adapting some of the content t…

It was a thoroughly enjoyable day and I have learnt many new techniques that I can see how I can implement in my working life. I especially enjoyed l…

Communication, ease of understanding and friendly

Good at talking us through the examples step by step at a steady pace. Tom was very clear and concise and I learned a lot!

Course delivery and content was excellent

Tom was a saint with his patience and enthusiasm, he was knowledgeable and again, as a beginner course was very good.

Explaining training, clear instructions, Tom was very approachable confident to ask questions.

Clear explanations, good 1 to 1 time where required

Taking the time to explain simple steps if anyone got lost

Great explanations and overall teaching method!

The trainer was very knowledgable, had a great attitude and was very patient with us asking lots of questions!

Everything! All aspects were explained really well and easy to follow. I really enjoyed my first excel training day!

Tom was amazing. Helped along the way whenever anyone got stuck, very approachable. Went at a speed that enabled everyone to keep up

Read course reviews

Who attends?

Career Progressives

Professionals who wish to develop skills for their current role and companies who believe in developing their talent.

Explore Careers

Career Changers

People seeking opportunities which require new skills. Industry relevant training for those pursuing a new role.

Explore Careers

Graduates

Certified courses for those who have earned their theoretical stripes, but need to prove capability to future employers.

Explore Careers

Learn Your Way

Face To Face

Learn face-to-face with expert mentors in a dynamic setting that inspires growth and confidence.

Explore Courses

Live Online

Join remotely with expert mentors in real time — flexible, interactive learning that fits your lifestyle.

Explore Courses

Team Training

Upskill your team together. Build your team and develop consistency, and collective confidence.

Explore Team Training

Three Steps To Success

Identify Your Path

Define your direction with purpose, aligning your learning journey to personal and career goals.

Learn With Experts

Gain practical insight from real-world experts who bring clarity, confidence, and momentum to your growth.

Earn Certification

Your certificate of attendance is proof of progress — benchmarking your skills and commitment to growth.

Microsoft Excel VBA Course