Visual Basic for Excel Advanced – VBA

Course Duration is 2 Days

£650.00 Plus VAT

Delivery Method

Face To Face Delivery  Virtual Delivery One To One Coaching Closed Group Course Public Course

Business Benefit

Building on the Introduction course this takes the user through more detailed commands and options in VBA allowing the user to create applications with custom front ends and add-ins.

Who Should Attend

The advanced Excel VBA course is ideally suited for individuals who already possess a basic understanding of VBA programming and wish to expand their skills to a more advanced level.

Learning Outcomes

Construction of an Application: Learn how to design and build a complete Excel application, incorporating various elements like user forms, menus, and automated processes.
Create Add-ins: Gain the ability to create custom Excel add-ins, extending Excel’s functionality and making your tools and features available across workbooks.
Understand Class Modules: Develop a deep understanding of class modules in VBA, allowing you to create custom objects with properties and methods for advanced programming.
Combine External Applications and Files: Learn how to integrate Excel with external applications and files, enabling data exchange and automation across different software.
Programmatically Create Charts: Master the skill of creating and manipulating charts programmatically in VBA, giving you control over chart design and data representation.
Create Pivot Tables in VBA: Discover how to create, modify, and manage Pivot tables using VBA, automating data analysis and reporting tasks.

Course Content

User Forms: User forms allow you to create custom interfaces for data entry and interaction within Excel. They are valuable for building user-friendly applications.
Workbook and Worksheet Events: Events in Excel trigger actions based on user interactions or changes in the workbook or worksheet. These events can automate tasks and improve user experience.
Dynamic List Items: Dynamically populating lists in user forms or worksheets enhances data validation and user input options.
Form Templates: Form templates allow you to create flexible and adaptable user forms that can change their content or appearance at runtime based on user input or conditions.
Ribbon Tabs and Toolbars: Customising the Excel ribbon with assigned macros and creating toolbars can provide quick access to frequently used functions and enhance productivity.
Menus and Add-Ins: Menus and add-ins help organise and extend Excel’s functionality by providing custom commands and features.
Class Modules: Class modules allow you to create custom objects with properties and methods, providing an object-oriented approach to VBA programming.
Data from External Files: Accessing and manipulating data from other Excel files expands data analysis and reporting capabilities.
Object Hierarchies: Understanding object hierarchies enables you to interact with other Microsoft Office applications, automating tasks and data exchange.
Data Storage in Windows Registry: Storing data in the Windows registry allows for configuration settings and data persistence between Excel sessions.
Charts in VBA: Creating charts programmatically in VBA provides control over chart design and data visualisation.
Pivot Tables: Creating and manipulating Pivot tables programmatically helps automate data analysis and reporting tasks.


How to Book

If you are interested in booking this course, then please select an available date and then click book now to complete the booking. Can’t see a suitable date contact us on [email protected] and we can discuss specific date requirements.


These follow up coaching sessions help support your colleagues to embed their learning during their skills transfer period.  Applying new skills and changing behaviour takes effort and practice.  After attending a training course many colleagues will find they need support through this transition.  EQV can provide that support with follow up coaching sessions to help embed the learning.

Embedding coaching sessions can be delivered in 90 minute and half day durations.  The facilitator will work with the group to capture feedback about challenges and how to overcome them ensuring success going forward.

Having a formal embedding coaching session will not only increase the success of the skills transfer period but helps create a platform of motivation, inclusivity and commitment within the group.