Share via

CommandBarButton.Index Property

  • Article
Office Developer Reference

Gets a Long representing the index number for an CommandBarButton object in the collection. Read-only.

Aa432913.vs_note(en-us,office.12).gif  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."

Syntax

expression.Index

expression   A variable that represents a CommandBarButton object.

Return Value
Integer

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 control is greater than 5, the control will be positioned as the first control on the command bar.

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

See Also