Microsoft Excel VBA Intermediate Course
Course Schedule
.svg){kind=small}
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 OUTLINE
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...
Master the basics of Microsoft Planner in this half-day virtual course. Learn to create plans, assign tasks, and collaborate with your team.
.svg){kind=small}
Half Day
Learn to transform, clean, and analyse data with Power Query. Import, merge, and create insightful reports in Excel. Half-day course.
Half day
This course is aimed at attendees who want to expand their knowledge into some of the more complex functions, build reports using form controls, work with Power Pivots and use built-in automation offered by Microsoft Excel.
1 day
.png){kind=small}
