The Advanced User Interfaces for Microsoft Office class is a hands-on workshop, scheduled to take a half day. Students will learn how to customize their Excel user interface, both for their own use and to enhance their VBA projects. This class is a supplement to Advanced Excel Charting with VBA and Intermediate Automation of Excel with VBA.
- The Office Ribbon
- RibbonX
- Custom Tabs
- Context Menus
- Control Types
- Callbacks
- Integration
- Advanced VBA Dialogs
- Message Box and Input Box
- User Forms
- Controls
- Methods
- Properties
- Working With Data
- Implementation
All classes offered by Peltier Technical Services have been developed by Jon Peltier of Peltier Tech. They assume an intermediate level of competency in Excel, and build on this base to develop strong skills. Attendees work on practical examples using their own notebook computers. Class materials include presentations and workbooks, as well as a handful of helpful utilities.
