CommandBarButton.Caption property (Office)

Gets or sets the caption text for a command bar control. Read/write.

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.Caption

expression A variable that represents a CommandBarButton object.

Return value

String

Example

This example adds a command bar control with a spelling checker button face to a custom command bar, and then it sets the caption to Spelling checker.

Set myBar = CommandBars.Add(Name:="Custom", _ 
Position:=msoBarTop, Temporary:=True) 
myBar.Visible = True  
Set myControl = myBar.Controls _ 
.Add(Type:=msoControlButton, Id:=2) 
With myControl 
    .DescriptionText = "Starts the spelling checker" 
    .Caption = "Spelling checker" 
End With

Note

A control's caption is also displayed as its default ScreenTip.

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.