CommandBarButton.Id property (Office)
Gets the ID for a built-in CommandBarButton control. Read-only.
Note
The use of CommandBars in some Microsoft Office applications has been superseded by the new ribbon component of the Microsoft Office Fluent user interface. For more information, see Overview of the Office Fluent ribbon.
Syntax
expression.Id
expression Required. A variable that represents a CommandBarButton object.
Remarks
A control's ID determines the built-in action for that control. The value of the Id property for all custom controls is 1.
Example
This example changes the button face of the first control on the command bar named Custom2 if the button's ID value is less than 25.
Set ctrl = CommandBars("Custom").Controls(1)
With ctrl
If .Id < 25 Then
.FaceId = 17
.Tag = "Changed control"
End If
End With
The following example changes the caption of every control on the toolbar named Standard to the current value of the Id property for that control.
For Each ctl In CommandBars("Standard").Controls
ctl.Caption = CStr(ctl.Id)
Next ctl
See also
Support and feedback
Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.