View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Rech Jim Rech is offline
external usenet poster
 
Posts: 2,718
Default Add Scroll Bar to CommandBar

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 a
msoControlButton, msoControlEdit, msoControlDropdown, msoControlComboBox and
msoControlPopup. The msoControlEdit may meet your need to a text box but
there is no scroll bar control.

--
Jim
"Anony" wrote in message
...
| 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