Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.



Press esc to close

close close

Back to course information

Thank you for your enquiry!

One of our training experts will be in touch shortly to go overy your training requirements.

close close

Thank you for your enquiry!

One of our training experts will be in touch shortly to go over your training requirements.

Course Information

Microsoft Excel VBA and Macro Training 

Module 1: Recorded Macros

  • Understanding Excel Macros 
  • Enable the Developer Tab
  • Record a Macro
  • Run a Macro
  • Edit a Macro
  • Macro Security
  • Saving a Document as Macro Enabled
  • Relative Cell References
  • Assigning a Macro to the Toolbar
  • Assigning a Keyboard Shortcut to a Macro 

Module 2: Understanding Excel VBA

  • Programming in Microsoft Excel
  • VBA Terminology 
  • VBA Editor Screen
  • Closing the Editor 
  • Viewing the Excel Object Model 
  • Using the Immediate Window 
  • Setting Property Values 
  • Working with Worksheets
  • Accessing Help 

Module 3: Starting with Excel VBA

  • Using the Project Explorer 
  • Working with the Properties Window
  • Working with a Code Module
  • Setting Breakpoints in Code

Module 4: Using Excel Objects

  • Application Object 
  • Workbook Object
  • Range Object 
  • Using Range Objects 
  • Using Objects in a Procedure

Module 5: Programming Techniques

  • MsgBox Function
  • InputBox Function
  • InputBox Method
  • Simple If Statement
  • If...Then…else Statement
  • Select Case Statement
  • Do Loop
  • Do Until Loop
  • Do While Loop
  • For Next Loop
  • For Each…Next Loop

Module 6: Creating Custom Forms

  • Creating Custom Forms
  • Adding Text Boxes to a Form
  • Changing Text Box Control Properties
  • Adding Label Controls to a Form 
  • Adding a Combo Box Control
  • Adding Option Buttons
  • Adding Command Buttons

Module 7: Procedures

  • Understanding Procedures
  • Creating a New Sub Routine 
  • IntelliSense 
  • Using the Edit Toolbar 
  • Commenting Statements 
  • Indenting Code 
  • Bookmarking in Procedures

Module 8: Using Variables

  • Understanding Variables 
  • Creating and Using Variables 
  • Explicit Declarations
  • Scope of Variables 
  • Understanding Passing Variables 
  • Declaring Data Types
  • Using Arrays

Module 9: Functions in VBA

  • Understanding Functions 
  • Creating User-Defined Functions
  • VARTYPE Function
  • Creating a Function Library 
  • Importing a VBA Module

Module 10: Error Handling

  • Understanding Error Types
  • Excel Objects
  • Handling Errors
  • Error-Handling Routine
  • On Error Statements
  • Error Statement
  • Untrapped Errors
  • Working with Err Object 

Show moredowndown

Who should attend this Microsoft Excel VBA and Macro Training Course?

This Microsoft Excel VBA and Macro Training Course is designed for individuals seeking to enhance their proficiency in Excel and automate tasks using VBA (Visual Basic for Applications) programming. This course can benefit a wide range of professionals, including:

  • Excel Users.
  • Analysts and Data Professionals.
  • Business Professionals.
  • Financial Experts.
  • IT Professionals.
  • Educators.
  • Administrative Staff.
  • Entrepreneurs and Small Business Owners.

Prerequisites of the Microsoft Excel VBA and Macro Training Course

There are no formal prerequisites for this Microsoft Excel VBA and Macro Training Course. However, a basic understanding of Microsoft Excel would be beneficial.

Microsoft Excel VBA and Macro Training Overview

Microsoft Excel VBA, also known as Visual Basic for Applications, is an internal programming language used by Microsoft Office programmes and is used to create programmes for the Windows operating system. VBA and macros allow users to automate solutions with the use of an intuitive action recorder and the ability to edit those recordings. Studying this training will speed up learners understanding of the VBA programming language in Excel and help them consistently perform repetitive actions on worksheets. Individuals with Excel and programming skills will be able to climb the success ladder by obtaining highly regarded positions in multinational corporations.

In this 1-day Microsoft Excel VBA and Macro Training course, delegates will obtain a solid understanding of Visual Basic for Applications (VBA) and macros. During this training, they will get knowledge of how to manage and regulate user input by creating user forms in Excel. They will also learn how to generate and duplicate a formula from many cells using relative references. Our highly expert trainer with years of teaching experience will conduct this course and help delegates get familiar with the use of Microsoft Excel for VBA and Macros.

Course Objectives

  • To comprehend the scope of a variable when working with variables.
  • To understand the concept of passing input parameters into a module.
  • To create solutions for complex problems by leveraging Excel functionality.
  • To identify an element that allows the input of free-form text.
  • To write custom VBA Macros for creating more robust automation.
  • To use IntelliSense to speed up development by decreasing keyboard input.

After attending this training, delegates will be able to automate processes and carry out several other tasks in addition to making and organising spreadsheets. They will also be able to use powerful techniques for editing macros and using Excel more efficiently.

Show moredowndown

What’s included in this Microsoft Excel VBA and Macro Training Course?

  • World-Class Training Sessions from Experienced Instructors  
  • Microsoft Excel VBA and Macro Training Certificate
  • Digital Delegate Pack

Show moredowndown

Why choose us

Ways to take this course

Our easy to use Virtual platform allows you to sit the course from home with a live instructor. You will follow the same schedule as the classroom course, and will be able to interact with the trainer and other delegates.

Our fully interactive online training platform is compatible across all devices and can be accessed from anywhere, at any time. All our online courses come with a standard 90 days access that can be extended upon request. Our expert trainers are constantly on hand to help you with any questions which may arise.

This is our most popular style of learning. We run courses in 1200 locations, across 200 countries in one of our hand-picked training venues, providing the all important ‘human touch’ which may be missed in other learning styles.


Highly experienced trainers

All our trainers are highly qualified, have 10+ years of real-world experience and will provide you with an engaging learning experience.


State of the art training venues

We only use the highest standard of learning facilities to make sure your experience is as comfortable and distraction-free as possible


Small class sizes

We limit our class sizes to promote better discussion and ensuring everyone has a personalized experience


Great value for money

Get more bang for your buck! If you find your chosen course cheaper elsewhere, we’ll match it!

This is the same great training as our classroom learning but carried out at your own business premises. This is the perfect option for larger scale training requirements and means less time away from the office.


Tailored learning experience

Our courses can be adapted to meet your individual project or business requirements regardless of scope.


Maximise your training budget

Cut unnecessary costs and focus your entire budget on what really matters, the training.


Team building opportunity

This gives your team a great opportunity to come together, bond, and discuss, which you may not get in a standard classroom setting.


Monitor employees progress

Keep track of your employees’ progression and performance in your own workspace.

What our customers are saying

Microsoft Excel VBA and Macro Training FAQs


Microsoft Excel is a spreadsheet programme originally developed by Microsoft for businesses all over the world. Excel allows the collection, processing, and manipulation of data in a tabular format.
Microsoft's Excel VBA programming language allows users to construct macros for automating time-consuming word processing and data processing tasks as well as creating custom graphs, reports, and forms.
In Microsoft Excel, VBA is useful for automating routine and repetitive processes, improving information accessibility for other users, speeding up turnaround, safeguarding workbooks, and hiding worksheets.
Excel macro is a set of actions that record, give a name, save, and run actions indefinitely. It allows you to save time on repetitive tasks involved in data reports and manipulation.
In this Microsoft Excel VBA and Macro Training course, you will learn about VBA-Excel macros, accessing the VBA editor, event handling, calling a function, user-defined functions, Textbox control properties, forms, explicit declarations, variables, and other essential topics.
The price for Microsoft Excel VBA and Macro Training certification in Belgium starts from €995
The Knowledge Academy is the Leading global training provider for Microsoft Excel VBA and Macro Training.

Why choose us


Best price in the industry

You won't find better value in the marketplace. If you do find a lower price, we will beat it.


Many delivery methods

Flexible delivery methods are available depending on your learning style.


High quality resources

Resources are included for a comprehensive learning experience.

barclays Logo
deloitte Logo
Thames Water Logo

"Really good course and well organised. Trainer was great with a sense of humour - his experience allowed a free flowing course, structured to help you gain as much information & relevant experience whilst helping prepare you for the exam"

Joshua Davies, Thames Water

santander logo
bmw Logo
Google Logo

Looking for more information on Microsoft Excel Training & Certification Course?

backBack to course information

Get a custom course package

We may not have any package deals available including this course. If you enquire or give us a call on +32 35001305 and speak to our training experts, we should be able to help you with your requirements.