Key Information
Duration: 1 Day days
Course Learning Skills: VBA 2013
Additional Material: Download Course Slides Link
Brief
We offer three one day Excel VBA courses to cover the three levels of Basic, Intermediate and Advanced. You can, if you wish, do all three over a three day period or combine any two over a two day period.
Also, you can mix and match modules from the three levels if you would prefer to tailor a course more suited to your needs.
Attendees
This course is for experienced users of Excel VBA looking to explore and utilise its more powerful features.
Prerequisites
Ideally each delegate should already be proficient in VBA and the manipulation of Excel objects. Those who have not done much VBA previously or would like a refresher are welcome to combine our intermediate course with this one over a two day period.
Benefits
Delegates will gain a broader understanding of advanced Excel VBA programming and be able to do each of the following:
- Supplement the Excel object hierarchy with their own objects
- Extend the Excel Add-In library with their own applications
- Exchange data with external applications and files
Construction of an application
- Overview of user forms
- Overview of Workbook and Worksheet events
- Application of dynamically populated List items
- Use of form templates to dynamically manipulate form display contents at runtime
- Assigning macros to ribbon tabs (toolbars)
- Creation and maintenance of menus
Add-ins
- Creation of add-in workbook
- Application of ribbon tab to invoke and control an add-in
- Application of Excel options window to activate an add-in
Class modules
- Overview of class module versus program module
- Creation of property and method procedures
- Use and manipulation of class modules
Combining with external applications and files
- Use of data from other Excel files
- Use of data text files
- Use of data databases via ODBC connections
- Use of object hierarchies in other Microsoft Office applications
- Data storage in the Windows registry
- Use of external dynamic link libraries (DLL files)
Charts
- Creation of a chart as a sheet or as an object within a sheet
- Application of formats to different chart areas and items
- Maintenance of data labels and values
- Maintenance of key attributes
Pivot tables
-
- Creation of a pivot table and definition of its source data
Manipulation of column and row headings
Manipulation of cell values
Application of grouping and filtering
Application of formats to different sections of a table