Add Scroll Bar to CommandBar

G

Guest

In terms of creating my own custom toolbar using VBA, what's the command to
add a horizontal scroll bar to the commandbar? What about an associated
textbox? Thanks.
 
J

Jim Rech

Don't confuse the controls available on a userform or a worksheet with those
on commandbars. Take a look at the Add method as it applies to
CommandbarControl objects in VBA help. The types of controls are:
msoControlButton, msoControlEdit, msoControlDropdown, msoControlComboBox and
msoControlPopup. The msoControlEdit may meet your need to a text box but
there is no scroll bar control.

--
Jim
| In terms of creating my own custom toolbar using VBA, what's the command
to
| add a horizontal scroll bar to the commandbar? What about an associated
| textbox? Thanks.
|
| ------
| Cheers,
| Anony
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top