How to attach command bar object label

Topic

New Reply

How to attach command bar object label
The .DescriptionText and .Caption property don

Reply | Quote

Replies

Use the Style property. 1 is icon only, 2 is text only (the Caption property is displayed) and 3 is icon plus text.

There are other choices, too (not available from the Toolbar Customize pop-up menus)…

From the Style Property help:

Use with the CommandBarButton object: Returns or sets the way a command bar button control is displayed. Can be one of the following MsoButtonStyle constants: msoButtonAutomatic, msoButtonIcon, msoButtonCaption, msoButtonIconAndCaption, msoButtonIconAndCaptionBelow, msoButtonIconAndWrapCaption, msoButtonIconAndWrapCaptionBelow, or msoButtonWrapCaption.

Hope this helps.

Reply | Quote

Sorry my command bar object is a combo box, not a button!

Reply | Quote

For a combo box, the Caption property should work! For example, if your Toolbar is named “MyToolbar” and the ComboBox control has a caption of, say, “Select from List”, then you can change the text displayed to the left of the combo box using the code:

CommandBars(“MyToolbar”).Controls(“Select from List”).Caption = “Pick from List”

Be sure to set its Style property to msoComboLabel (=1).

Reply | Quote

Yes, it works! Thanks!

Reply | Quote