Add Scroll Bar to CommandBar

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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
 
Back
Top