I'm not sure you can.

If you add a combobox to a userform, it has a .listrows property that you can
specify that number of rows to show. I don't see that property in the combobox
placed on a commandbar.

But maybe someone will see a way to do this...

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


--

Dave Peterson