Share via

CommandBarButton Object

  • Article
Office Developer Reference

Represents a button control on a command bar.

Aa432093.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."

Example

Use Controls(index), where

index

is the index number of the control, to return a CommandBarButton object. Note that the Type property of the control must be msoControlButton. Assuming that the second control on the command bar named "Custom" is a button, the following example changes the style of that button.

Visual Basic for Applications 
  Set c = CommandBars("Custom").Controls(2)
With c
If .Type = msoControlButton Then
    If .Style = msoButtonIcon Then
        .Style = msoButtonIconAndCaption
    Else
        .Style = msoButtonIcon
    End If
End If
End With
Aa432093.vs_note(en-us,office.12).gif  Note
You can also use the FindControl method to return a CommandBarButton object.

See Also