ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Add Scroll Bar to CommandBar (https://www.excelbanter.com/excel-programming/395073-add-scroll-bar-commandbar.html)

Anony

Add Scroll Bar to CommandBar
 
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

Jim Rech

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




All times are GMT +1. The time now is 12:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com