Microsoft Excel VBA Intermediate Course
Take your Excel VBA skills further
The Microsoft Excel VBA Intermediate course is intended for users who can already create and edit straightforward macros and now want to build more capable automated Excel solutions.
Participants will develop their understanding of VBA programming structures and learn how to create code that can make decisions, repeat actions and respond to different situations. These techniques allow macros to move beyond simple recorded sequences and become more flexible and reusable.
Develop more reliable Excel automation
As VBA solutions become more complex, it becomes increasingly important to structure code clearly and understand how different parts of a procedure interact.
Through practical exercises, participants will gain experience of writing and modifying VBA code and develop greater confidence when identifying and correcting problems.
The course provides a natural progression from Microsoft Excel VBA Introduction and prepares experienced users for the more sophisticated programming techniques covered in Microsoft Excel VBA Advanced.
Not sure which Excel course is right for you?
Take our free Excel Skills Assessment and receive an instant recommendation based on your current Excel knowledge and experience.
Need a quick explanation of an Excel term? Browse our free Excel Glossary.
Course Schedule
.svg){kind=small}
Course Code: EXCEL6
Duration: 1 day
Course Aims
This course is aimed at people who wish to improve on their existing basic knowledge of VBA and enhance their knowledge and appreciation of the concepts, tools and techniques of VBA programming.
Our Microsoft Excel course is delivered using the latest version available through Microsoft 365. This ensures that our demonstrations include the most up-to-date features and functions. While many of the concepts and techniques covered are applicable to earlier versions of Excel, there may be some differences in the user interface and available features. If you are using an older version of Excel, our trainers are happy to provide guidance on how to access similar functionalities within your version.
Course Objectives
By the end of this course, you will be able to:
- Declare and use variables and constants confidently, selecting suitable data types and naming conventions.
- Control scope and visibility (procedure-level, module-level and public) to create clearer, more maintainable code.
- Build and work with arrays, including populating arrays with loops and using dynamic arrays where needed.
- Create User-Defined Functions (UDFs) for use in worksheets, including calling Excel worksheet functions within VBA.
- Design and build UserForms, adding controls, setting properties, and applying practical layout techniques.
- Write VBA to control UserForms, including initialising forms, responding to events, validating input, and writing results to worksheets.
- Use ActiveX controls on worksheets and understand when they are a good alternative to UserForms.
- Apply debugging and error-handling techniques to fix issues quickly and make your VBA solutions more robust.
Course Prerequisites
Students who wish to attend this course need to have significant experience and ability at understanding and using Excel advanced functionality and have attended the Microsoft Excel VBA Introduction course.
Course Content
Variables, Constants and Arrays
- Declaring Variables
- Scope and Visibility
- Creating and Defining Arrays
- Assigning Values to an Array
- Filling Arrays Using Loops
- Dynamic Arrays
Create User Defined Functions
- Using Excel Worksheet Functions in VBA
- VBA Functions
- User-Defined Functions
- Declaring Variables in User Defined Functions
Create User forms
- User-Defined Forms
- Adding Controls to a Form
- Form Controls Design Tools and Techniques
- Form Control Properties
- Programming a User Form
- Displaying a User Form
- Using ActiveX Controls directly on a Worksheet
Error Trapping and Debugging
Related Courses
Public Schedule
Private Virtual Training (Teams / Zoom)
£1,295 + VAT per day for up to 8 delegates (≈ £162 per person)
Private Onsite Training (at your offices)
Same day rate as Private Virtual, plus trainer travel expenses (confirmed in your quote)
Note
All prices exclude VAT at 20%.
VAT registration number: 450 4347 14
You may also like...
Learn to use Microsoft Planner to create plans, organise and assign tasks, track progress and collaborate effectively with colleagues.
.svg){kind=small}
Half day
Learn Excel Power Query to import, clean, transform, merge and reshape data, then load repeatable queries for reporting and analysis.
Half day
Master advanced Excel functions, XLOOKUP, dynamic arrays, What-If Analysis, PivotTables and Power Pivot for more powerful reporting and data modelling.
1 day
.png){kind=small}
