An Excel VBA Course teaches you how to use Visual Basic for Applications within Microsoft Excel to control spreadsheet actions and automate repetitive processes. This course starts with macro recording before introducing VBA syntax, Excel objects, variables, logic, loops, error handling and events.
Overview of Excel VBA Course Online
Excel can handle complex calculations and large amounts of information, but many users still spend valuable time repeating the same spreadsheet tasks manually. If you regularly update cells, manage worksheets, process workbooks or perform recurring actions, learning VBA can help you work more efficiently.
The Excel VBA and Macros Foundations Course takes you beyond everyday spreadsheet use and introduces the programming tools behind Excel automation. You will begin by understanding the difference between recording macros and writing VBA, before learning how to record basic macros and work with absolute and relative references.
From there, you will explore the Visual Basic Editor, VBA syntax and the Excel object model. You will learn how to work programmatically with ranges, cells, worksheets and workbooks before progressing to variables, constants and procedures.
As your confidence develops, the course introduces essential programming logic through IF statements, CASE statements and logical operators. You will also explore FOR, FOR EACH and DO loops, helping you understand how VBA can repeat actions automatically instead of requiring the same manual steps again and again.
The later sections take your Excel VBA Training further with message boxes, input boxes, error handling, debugging and worksheet and workbook events. This gives you a structured foundation for creating more responsive and automated Excel processes.
Current UK VBA training similarly emphasises macros, the VBA environment, objects, variables, control structures and automation as important skills for learners who want to extend Excel beyond standard spreadsheet functionality.
Whether you work with spreadsheets professionally or simply want to develop stronger Excel skills, this course provides an accessible route into VBA programming and Excel automation.
Exclusive Course Glimpse
Learning Outcomes
By completing this Excel VBA Course, you should be able to:
- Explain the difference between recording macros and writing VBA.
- Record basic macros using absolute and relative references.
- Navigate the Visual Basic Editor and work with modules.
- Understand fundamental VBA syntax, objects, properties and methods.
- Manipulate ranges and cells using VBA code.
- Add, select, copy, move and delete worksheets.
- Open, save, close and reference Excel workbooks.
- Declare and use variables, object variables and constants.
- Create decision-making logic using IF, ELSEIF and CASE statements.
- Automate repeated actions using FOR, FOR EACH and DO loops.
- Capture user information with message boxes and input boxes.
- Apply basic VBA error-handling and debugging techniques.
- Use worksheet and workbook events to trigger code.
Why Choose This Excel VBA and Macros Course?
Learning VBA can seem intimidating if you have never programmed before. This Excel VBA and Macros Course provides a structured progression from familiar Excel tasks into programming and automation.
- Start with macro recording – understand automation before progressing into written code.
- Learn VBA foundations – develop knowledge of syntax, variables, objects and procedures.
- Work with real Excel components – control cells, ranges, worksheets and workbooks.
- Develop programming logic – use conditions, operators and loops to control your code.
- Explore Excel automation – discover how VBA can reduce repetitive spreadsheet actions.
- Build troubleshooting knowledge – work with errors, breakpoints and debugging concepts.
- Understand event-driven VBA – trigger actions when something happens within a worksheet or workbook.
- Study flexibly online – develop your skills around work and other responsibilities.
Rather than stopping at basic macro recording, the curriculum progresses into VBA logic, looping, user interaction, error handling and events, giving you a broader foundation for continued Excel automation learning.
Certificate of Achievement
- CPD Accredited Certificate
- Digital Certificate
- Professional Recognition
- CV and LinkedIn Enhancement
- Proof of Professional Skills
Who Is This Course For?
This course is particularly suitable for:
- Excel users who regularly perform repetitive spreadsheet tasks
- Administrators and office professionals
- Finance and accounting staff
- Reporting and data professionals
- Business and operations professionals
- Analysts who regularly work with Excel
- Learners interested in Excel automation
- Anyone wanting a foundation in VBA programming
No previous VBA programming experience is required, although basic confidence using Microsoft Excel will make it easier to follow the practical concepts.
Career Opportunities in the UK
VBA is best positioned as a supporting workplace skill, rather than suggesting that completing one course directly qualifies someone for a particular profession. Excel and spreadsheet automation can be useful across finance, administration, analysis, reporting and operational roles.
Data Analyst
Data analysts collect, organise and examine data to identify trends and useful information. Excel remains relevant in many analytical environments, and VBA knowledge can help with recurring spreadsheet processes and automation.
Typical UK salary: approximately £23,000–£62,000 per year, depending on experience and responsibility.
Business Analyst
Business analysts examine organisational processes, systems and information to identify opportunities for improvement. Strong Excel skills can complement wider analytical, communication and problem-solving capabilities.
Typical UK salary: approximately £23,000–£55,000 per year.
Finance Officer
Finance officers may work with financial records, invoices, budgets, reports and spreadsheets. VBA and macros can be useful supporting skills where recurring Excel processes are part of the role.
Typical UK salary: approximately £19,500–£34,000 per year.
Office Manager
Office managers oversee administrative systems, staff and day-to-day office operations. Advanced spreadsheet skills can be valuable where teams rely on Excel for records, reports and recurring administrative processes.
Typical UK salary: approximately £25,000–£40,000 per year.
This Excel VBA Training can therefore strengthen practical spreadsheet capability relevant to several career paths, but employment will depend on the wider skills, experience and qualifications required for each role.
Entry Requirements
- No previous VBA programming experience is required.
- A working knowledge of Microsoft Excel is recommended.
- Basic familiarity with cells, worksheets and workbooks will be helpful.
- Access to a suitable version of Microsoft Excel is recommended for practice.
- An internet-connected device is required for online learning.
Turn repetitive spreadsheet work into an opportunity to work smarter. Learn how Excel macros and VBA operate, build practical programming foundations and develop the confidence to explore more efficient, automated Excel workflows.
Order Your Certificate
To order your Certificate, we kindly invite you to visit the following link
Frequently Asked Questions -
Yes. The course starts with foundational topics such as activating the Developer tab, recording a basic macro and understanding VBA syntax before progressing to programming concepts. You do not need previous VBA programming experience, although basic Excel knowledge is recommended.
A macro is a sequence of actions that can automate tasks in Excel. Excel can record your actions and generate VBA code behind the macro. VBA is the programming language that allows you to understand, edit and write code to create more customised Excel processes. This course covers both approaches.
Yes. Excel automation is an important practical theme throughout the curriculum. You will learn how VBA can work with cells, ranges, worksheets and workbooks, as well as how conditions, loops and events can control and trigger repeated actions.
Yes. The Excel VBA Training introduces VBA syntax, objects, variables, constants, procedures, logical operators, IF and CASE statements, FOR and DO loops, user interaction and error handling. It provides a foundation in practical VBA programming specifically within Excel.
Yes. Dedicated sections cover IF, ELSEIF and nested IF structures, CASE statements and logical operators. You will also explore FOR NEXT, FOR EACH, DO, DO UNTIL and DO WHILE loops, helping you understand how VBA makes decisions and repeats actions.
Yes. You will explore different error types, On Error techniques, the Err object and breakpoints. These topics introduce you to identifying problems and making VBA procedures more manageable when errors occur.
The curriculum covers important Excel VBA objects and collections, including Range, Cells, Sheets, Worksheets and Workbooks. You will learn how VBA can reference and manipulate these elements as part of spreadsheet automation.
Yes. The later part of the course provides extensive coverage of worksheet and workbook events. This includes events related to changes, activation, saving, opening, closing, printing and other Excel actions, helping you understand how code can run automatically when specified events occur.
After successfully completing the course, you can receive the available course certificate as evidence of completion and continuing professional development. The certificate should not be confused with a Microsoft professional certification.
Course Curriculum
| Section 01: Introduction | |||
| Recording Macros vs Writing VBA | 00:04:00 | ||
| Understanding Objects in Excel VBA | 00:07:00 | ||
| Understanding VBA Syntax and Parts of Speech | 00:10:00 | ||
| Activating the Developer tab | 00:01:00 | ||
| Recording a basic Macro | 00:05:00 | ||
| Absolute vs Relative Macro recording | 00:04:00 | ||
| Section 02: Exploring the Visual Basic Environment | |||
| Introduction to the Visual Basic Environment | 00:02:00 | ||
| The Project Explorer | 00:02:00 | ||
| The Properties Window | 00:02:00 | ||
| The Code Window | 00:04:00 | ||
| Immediate, Locals and Watch Window | 00:03:00 | ||
| Dealing with Modules | 00:03:00 | ||
| Comments in Excel VBA | 00:01:00 | ||
| Section 03: The Range Object | |||
| Introduction and Changing Cell Values | 00:10:00 | ||
| Adding a text to a cell | 00:01:00 | ||
| Dealing with Named Ranges | 00:03:00 | ||
| Value vs Text Property | 00:04:00 | ||
| Row and Column properties | 00:02:00 | ||
| The Select Method | 00:02:00 | ||
| The Count Property | 00:04:00 | ||
| The Address Property | 00:09:00 | ||
| The Formula Property | 00:03:00 | ||
| The Number Format Property | 00:07:00 | ||
| The Font Property | 00:08:00 | ||
| Section 04: Understanding the Cells Collection Object | |||
| What is the cells object? | 00:06:00 | ||
| Using the Cells collection to affect cells positionally within a range | 00:05:00 | ||
| Affecting all cells within a sheet | 00:02:00 | ||
| Combining Range and cells objects | 00:03:00 | ||
| Section 05: Working with Sheets/Worksheets | |||
| Selecting Sheets | 00:06:00 | ||
| Adding Sheets | 00:11:00 | ||
| Sheets vs Worksheets | 00:04:00 | ||
| Copying Sheets | 00:05:00 | ||
| Moving Sheets | 00:01:00 | ||
| Deleting Sheets | 00:04:00 | ||
| Section 06: Understanding Variables in Excel VBA | |||
| Introduction to Variables | 00:06:00 | ||
| Variable Data Types | 00:09:00 | ||
| Declaring Variables | 00:14:00 | ||
| Object Variables | 00:08:00 | ||
| Calling a procedure from Another Procedure & Variable Scope | 00:03:00 | ||
| Public and Private Variables | 00:07:00 | ||
| Declaring Constants | 00:04:00 | ||
| Exercises-Variables | 00:06:00 | ||
| Section 07: Dealing with Workbooks | |||
| Referring to Workbooks-Different ways | 00:04:00 | ||
| Closing Workbooks | 00:03:00 | ||
| Adding and Saving Workbooks Part 1 – Save method | 00:04:00 | ||
| Adding and Saving Workbooks Part 2 – Save as method | 00:10:00 | ||
| Opening Workbooks | 00:06:00 | ||
| Section 08: Must Know Excel VBA Logic | |||
| Finding the Last row | 00:09:00 | ||
| Finding the Last Column | 00:04:00 | ||
| Finding the next row | 00:04:00 | ||
| The WITH Statement | 00:04:00 | ||
| Comparison operators in Excel VBA | 00:01:00 | ||
| IF Statements- Simple IF Statements | 00:07:00 | ||
| IF THEN ELSE Structure | 00:03:00 | ||
| IF THEN ELSEIF Structure | 00:07:00 | ||
| Nested IFs | 00:04:00 | ||
| OR – AND logical operators | 00:07:00 | ||
| NOT Logical operator | 00:03:00 | ||
| CASE Statements Part 1 – Single Case Statements | 00:09:00 | ||
| CASE Statements Part 2 – Nested Case Statements | 00:06:00 | ||
| Case Statements-Exercise | 00:01:00 | ||
| GOTO and Labels | 00:03:00 | ||
| Section 09: Looping in Excel VBA | |||
| Loops-Introduction | 00:01:00 | ||
| FOR NEXT Loop | 00:11:00 | ||
| Exit For | 00:09:00 | ||
| Exercise – For Next loop | 00:01:00 | ||
| FOR EACH Loop – Intro | 00:07:00 | ||
| FOR EACH Loops – More examples | 00:05:00 | ||
| Do Loop – Introduction | 00:04:00 | ||
| Do Loop Example | 00:01:00 | ||
| Do Until | 00:02:00 | ||
| Do While | 00:02:00 | ||
| Do while vs Do until – Movies Example | 00:04:00 | ||
| Exit Do Statement | 00:05:00 | ||
| Exercise – Do Loop | 00:01:00 | ||
| Section 10: Interacting with Your Users | |||
| The Messagebox – Introduction | 00:03:00 | ||
| Messagebox -Inputs | 00:07:00 | ||
| Messagebox – Capturing the User’s input | 00:05:00 | ||
| Adding a new line to your VBA Strings | 00:02:00 | ||
| The Inputbox – introduction | 00:04:00 | ||
| Inputbox – Example1 – Capturing a user’s name | 00:05:00 | ||
| Inputbox -Employee Database Example Part 1 | 00:05:00 | ||
| Inputbox -Employee Database Example Part 2 | 00:04:00 | ||
| Exercise – InputBox | 00:02:00 | ||
| Section 11: Error Handling in Excel VBA | |||
| Error Handling – Introduction | 00:09:00 | ||
| Different Error types in action | 00:04:00 | ||
| On Error Goto statement | 00:04:00 | ||
| Resetting the error handling Status with On Error Goto | 00:02:00 | ||
| The Err Object | 00:07:00 | ||
| Setting a Breakpoint | 00:02:00 | ||
| Section 12: Triggering Code with Events! | |||
| Worksheet Events -Selection change | 00:08:00 | ||
| Worksheet Events – Worksheet Activate event | 00:03:00 | ||
| Worksheet Events – Deactivate event | 00:02:00 | ||
| Worksheet Events – Before Delete Event | 00:02:00 | ||
| Worksheet Events – Before Double click event | 00:08:00 | ||
| Worksheet Events – Before Right Click event | 00:03:00 | ||
| Worksheet Events – Calculate event | 00:03:00 | ||
| Enabling and Disabling Events | 00:03:00 | ||
| Worksheet events – Worksheet change event | 00:11:00 | ||
| Worksheet events – Follow Hyperlink event | 00:03:00 | ||
| Worksheet events -Exercise | 00:01:00 | ||
| Workbook Events – Workbook open event | 00:05:00 | ||
| Workbook Events – Workbook Activate event | 00:02:00 | ||
| Workbook Events – Workbook Before save event | 00:06:00 | ||
| Workbook Events – Workbook Aftersave event | 00:04:00 | ||
| Workbook Events – Workbook Beforeclose event | 00:09:00 | ||
| Workbook Events – Workbook BeforePrint event | 00:03:00 | ||
| Workbook Events -Workbook De-activate events | 00:02:00 | ||
| Workbook Events – New Chart event | 00:08:00 | ||
| Workbook Events -New sheet event | 00:03:00 | ||
| Workbook Events – Sheet calculate event | 00:03:00 | ||
| Workbook Events – Sheet De-activate event | 00:06:00 | ||
| Workbook Events – Follow Hyperlink event | 00:02:00 | ||
| Workbook Events – Workbook Window Activate event | 00:06:00 | ||
| Workbook Events – Workbook Window De-Activate event | 00:02:00 | ||
| Workbook Events – Window Resize event | 00:02:00 | ||
| Exercise- Workbook Events | 00:01:00 | ||
| Order Your Certificate | |||
| Order Your Certificate | 00:00:00 | ||
Related Courses
