A master class from the Financial Analysis VBA Certificate Master Class series
An Extension of Australia’s premier Excel VBA course for finance professionals
This two-day master class focuses on issues around building the user interface using the customisations of the Ribbon, Quick Access Toolbar and Context Menus. It also deals with handling critical workbook and worksheet events. It demonstrates proven techniques for integrating these key elements of the user interface to build powerful, robust, user-friendly interfaces.
Course Content
Downloadable master class brochure with detailed course outline in PDF format (97kb).
Modes of Study
- In class mode: 16 hours over two days.
- Public offerings starting in Sydney in 2016.
- Private offerings also available.
Key Outcomes
- Gain advanced skills in key subject areas, such as working with the Ribbon interface;
- Working with and debugging Ribbon XML;
- Installing and using the Custom UI editor;
- Implementing ribbon call-back routines, making controls context sensitive;
- Building dynamic ribbon controls;
- Customising the built-in context menus;
- Responding to key Workbook and Worksheet events to automate tasks; and
- Up to 16 hours of continuing professional education.
Each Master Class Delivers
- Core knowledge for the specialised subject area;
- Re-usable examples demonstrating proven methodologies;
- Guidance on how to avoid real-world issues and problems; and
- Advanced techniques to build powerful and robust solutions without needless complexity.
Who Benefits
Those who have previously completed the Financial Analysis VBA Certificate or Downloadable master class brochure with detailed course outline in PDF format (97kb). Downloadable course brochure with detailed course outline in PDF format (93kb). Find a suitable course by reviewing the article Which Course Would Best Suit me? Find an offering in the Course Calendar.Detailed Course Outline & Other Information