Adding items to Ribbon dropdown using VB.NET

drop-down-menu, excel, ribbon, vb.net, vsto

Solution

Looks like you're on the right track. You need to first use the factory to create a new `RibbonDropDownItem`, give the new control the label you want, and then add the control to the parent `ComboBox`.

RibbonDropDownItem rdi = 
    Globals.Factory.GetRibbonFactory().CreateRibbonDropDownItem();
rdi.Label = "My Label";
Globals.Ribbons.Ribbon1.DropDown1.Items.Add(rdi);

Problem

I am new to developing Excel VSTO solutions and need a little help on how to add further items to a dropdown control on the ribbon. So far I have been able to create a number of items manually and then afterwards change the label of these items using ``` Globals.Ribbons.Ribbon1.DropDown1.Items(i).Label ``` Furthermore I found that some recommend using this to add further items to the dropdown control. But I am having a hard time trying to understand how to use it. ``` Globals.Factory.GetRibbonFactory.CreateRibbonComboBox.Items.Add ``` I would like to see a sample of how others have done it.

Original source