Advanced VBA

Advanced VBA

Updated Jun 23, 2024

What you'll learn

  • Learn to use VBA and Macros to automate tedious Excel jobs.
  • Learn how to write and implement Excel events.
  • Discover how to modify various standard behaviors, such as double-clicking, opening files and saving files.
  • Learn how to design and implement specialized classes of objects.
  • Discover how to customize the right-click menu in Excel.
  • Learn how you can extend the capability of VBA using external libraries.
  • Learn how to use VBA code to modify the Excel user interface, including the ""Ribbon"" and context menus.
Course Description

If you have used VBA in the past but are looking to expand your capability in Visual Basic Applications, then this Advanced VBA course is for you.

VBA, or Visual Basic for Applications, is like Excel on steroids. As an advanced feature, it can seem intimidating at first. But with just a little VBA knowledge, you'll be able to automate tasks in Excel and turbocharge your data handling capabilities.

Course Prerequisites
This course assumes you have a basic understanding of VBA in Excel. Including, but not limited to: using Macros to automate basic tasks, a grasp of the VBA editor, an understanding of looping, logical constructs and subroutines.

Please see the Filtered VBA for Beginners course if you are new to VBA in Microsoft Excel.

Course Details
This is a video-led training VBA training course with accompanying downloadable exercises.