Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 35
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
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


Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Cannot scroll with a Scroll Point Mouse Jeff (North Carolina) Excel Discussion (Misc queries) 2 January 7th 09 07:39 PM
Adding a scroll bar to a cell to scroll its contents. SkyKid Excel Programming 9 October 17th 07 09:14 PM
adding scroll bar to scroll on cell's content? Rotem Charts and Charting in Excel 0 November 16th 06 12:36 PM
Scroll horizontaly with mouse, create same system used to scroll . frederic New Users to Excel 5 October 9th 05 08:15 PM
Scroll the screen view with the scroll bar avbs Excel Discussion (Misc queries) 1 June 25th 05 04:43 PM


All times are GMT +1. The time now is 08:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"