An alternative to Dave's sheet navigator is code from Bob Phillips.

See this google search thread for the BrowseSheets macro from Bob
Phillips.

http://tinyurl.com/yoa3dw

You should easily be able to fit 60-70 sheets onto the Form.


Gord Dibben MS Excel MVP

On Sat, 14 Feb 2009 12:37:02 -0800, Tondos
wrote:

Dave,

My question is in relation to this older posting about expanding dropdown
lists to include all choices, not just 8-12.

I'm currently using your 'myNavigator' code to create a floating toolbar
that opens each time I start Excel. The toolbar has a dropdown in it with
the names of all worksheets in the open workbook. How do I expand the
dropdown list so that all 60-70 worksheet names appear WITHOUT needing to
scroll?
Thanks.
Tondos

"Dave Peterson" wrote:

If it's a combobox from the control toolbox toolbar, you can go into design mode
(another icon on that control toolbox toolbar), then click the properties icon.

Look for ListRows and change it to what you want.


If it's a dropdown from the Forms toolbar:
Rightclick on it and choose Format Control.
On the Control tab, change the drop down lines to what you want.


If it's a data|validation dropdown, you're stuck with what excel gives you.


theslaz wrote:

I had to check. I believe it is a combo box!

--
theslaz
------------------------------------------------------------------------
theslaz's Profile: http://www.thecodecage.com/forumz/member.php?userid=44
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=35320

--

Dave Peterson