dropdown list boxes

  • Thread starter Thread starter John Baker
  • Start date Start date
J

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?
 
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
 
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
 
Back
Top