CommandBarButton Object

CommandBarButton CommandBar

Represents a button control on a command bar.

Using the CommandBarButton Object

Use Controls(index), where index is the index number of the control, to return a CommandBarButton object. (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.

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

You can also use the FindControl method to return a CommandBarButton object.

Properties | Application Property | BeginGroup Property | BuiltIn Property | BuiltInFace Property | Caption Property | Creator Property | DescriptionText Property | Enabled Property | FaceId Property | Height Property | HelpContextId Property | HelpFile Property | HyperlinkType Property | Id Property | Index Property | IsPriorityDropped Property | Left Property | Mask Property | OLEUsage Property | OnAction Property | Parameter Property | Parent Property | Picture Property | Priority Property | ShortcutText Property | State Property | Style Property | Tag Property | TooltipText Property | Top Property | Type Property | Visible Property | Width Property

Methods | Copy Method | CopyFace Method | Delete Method | Execute Method | Move Method | PasteFace Method | Reset Method | SetFocus Method

Events | Click Event

Parent Objects

Child Objects | CommandBar Object