Ribbon, Context Menus & Handling Events Master Class

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 Financial Analysis Systems Certificate looking for support & guidance to extend their knowledge in building robust applications that need to be distributed to other users, robust and user-friendly.

Benefits for the Employer

  • A reduction in the effort required by staff to expand into key advanced topics;
  • Access to proven and effective strategies for advanced application and code building; and
  • A development path for key staff involved in creation of automated processes within the finance function.

Detailed Course Outline & Other Information

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.

Courses VBA Course