Course Overview
Our Excel VBA Level 2 course is designed for experienced Excel VBA developers who are familiar with working with the Excel object model and ready to develop complete, standalone applications.
CourseMonster only uses quality Microsoft training suppliers who have been through our rigorous standards to ensure that you receive the best quality training available.
Related Courses
Audience
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
If you would prefer the flexibility of online training, use the link(s) below:
More Online Training>>
