Index Property

Applies To

CommandBar object, CommandBarButton object, CommandBarComboBox object, CommandBarControl object, CommandBarPopup object.

Description

Returns the index number of the specified object in the collection. Read-only Long.

Remarks

The position of the first command bar control is 1. Separators are not counted in the CommandBarControls collection.

Example

This example searches the command bar named "Custom2" for a control with an ID value of 23. If such a control is found and the index number of the found control is greater than 5, the control will be positioned as the first control on the command bar.

Set myBar = CommandBars("Custom2")
Set ctrl1 = myBar.FindControl(Id:=23)
If ctrl1.Index > 5 Then
    ctrl1.Move before:=1
End If