Note
The use of CommandBars in some Microsoft Office applications has been superseded by the new Ribbon user interface. For more information, search help for the keyword "Ribbon."
Represents a combo box control on a command bar.

Remarks

Use Controls(index), whereis the index number of the control, to return a CommandBarComboBoxobject. Note that the Typeproperty of the control must be msoControlEdit, msoControlDropdown, msoControlComboBox, msoControlButtonDropdown, msoControlSplitDropdown, msoControlOCXDropdown, msoControlGraphicCombo, or msoControlGraphicDropdown.

Example

The following example adds two items to the second control on the command bar named Custom, and then it adjusts the size of the control.

Visual Basic for Applications 
Set combo = CommandBars("Custom").Controls(2) With combo .AddItem "First Item", 1 .AddItem "Second Item", 2 .DropDownLines = 3 .DropDownWidth = 75 .ListIndex = 0 End With

You can also use the FindControl method to return a CommandBarComboBox object. The following example searches all command bars for a visible CommandBarComboBox object whose tag is "sheet assignments."

Visual Basic for Applications 
Set myControl = CommandBars.FindControl _ (Type:=msoControlComboBox, Tag:="sheet assignments", Visible:=True)
Command Bar Combo Box Object commandbarcombobox commandbarcombobox object find visible command bar combo box object which is a specific tag ofv select a combo box control on a command bar use a control with an index number to return a command bar combo box object

See also:

index