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