Home / MS-Excel / General Formatting

Creating Excel Custom Controls

With your custom tab added to the Ribbon and populated with at least one custom group, you're ready to bring your RibbonX extensions into the realm of the practical by adding controls that actually perform actions. The rest of this tutorial takes you through the three most common control types supported by the Ribbon interface: buttons, menus, and split buttons. You'll learn the RibbonX XML code required to add and configure each control, as well as the VBA code needed to make a control perform an action.

In this tutorial:

  1. Common Control Attributes
  2. Creating a Button
  3. Creating a Menu
  4. Creating a Split Button
  5. Creating a Check Box
  6. Creating a Toggle Button
  7. Creating a Drop-Down List
  8. Creating a Gallery
  9. Creating a Combo Box
  10. Creating a Dialog Launcher
  11. Working with Ribbon Commands at Runtime
  12. Initializing Controls
  13. Resetting Controls
  14. Getting and Changing Control Values