Excel VBA Advanced

Our Excel VBA Level 3 course is designed for experienced Excel VBA developers who are familiar with working with the Excel object model.

Course Outline

Developing applications

Types of applications, Types of end-user, Analysing end-user needs, Planning an application, Planning the user interface

Working with events

Overview of event types, Event-handler procedures, Workbook events, Worksheet events, Chart events, UserForm events, Activate event, Save events, Change events, Focuse events, Click events

Creating Add-ins

Add-ins defined, Creating an add-in, Installing and add-in, Controlling add-ins with VBA, Add-ins collection, Add-in properties, Add-in events, Potential problems with add-ins

Command bars

Overview of command bars, Built-in command bars, The CommandBars collection, Types of command bar, Creating a command bar, Referencing command bars, Command bar properties, Command bar controls

Custom menus

Testing to see if a menu exists, Creating a new menu, Adding items to a menu, Adding items to shortcut menus

File manipulation

Opening a text file, Writing a text file, Importing data from a text file, Searching for text in files, Verifying if a file exists, Listing all files in a given folder

Class modules

Class modules defined, When to use class modules, Creating a class module, Property procedures, Method procedures