Hi All,

Is there a way to increase the number of lines (it seems to be 8) displayed
at a time (without scrolling) in a data validation dropdown list?

Thanks,
Stefi

Hi Stefi

The list size in Data Validation is fixed at 8.
If you want to alter the number, you would need to change to a Combo Box
instead.
For more information on setting up a Combo box for the purpose take a look
at Debra Dalgleish's site
http://www.contextures.com/xlDataVal10.html

Regards

Roger Govier


Stefi wrote:
Hi All,

Is there a way to increase the number of lines (it seems to be 8) displayed
at a time (without scrolling) in a data validation dropdown list?

Thanks,
Stefi

Thanks Roger, I'll look it up!

Stefi


€žRoger Govier€� ezt Ã*rta:

Hi Stefi

The list size in Data Validation is fixed at 8.
If you want to alter the number, you would need to change to a Combo Box
instead.
For more information on setting up a Combo box for the purpose take a look
at Debra Dalgleish's site
http://www.contextures.com/xlDataVal10.html

Regards

Roger Govier


Stefi wrote:
Hi All,

Is there a way to increase the number of lines (it seems to be 8) displayed
at a time (without scrolling) in a data validation dropdown list?

Thanks,
Stefi