dropdown list boxes

[John Baker]

I have created dropdown list boxes on a sheet using values from another
sheet.
The dropdowns show 8 values and to see more values the user needs to scroll
down further. Is there a way to increase the number of values that the user
can see before scrolling?

 

[Dan E]

If it's from the Forms toolbox
Right Click and choose Format control...
Under control just change the # in Drop Down Lines

If it's from the Control toolbox
Right Click and choose Properties
In the ListRows Property change the #

Dan E

 

[Andy Brown]

John,

If you used data validation to create it, I believe you're stuck with 8.

If it's a box from the Forms toolbar, you can right-click it and set the
number of dropdown lines on the Control tab.

If it's a box from the Control ToolBox, right-click it (in Design mode), go
into Properties and change the ListRows value.

Rgds,
Andy