View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Stefi
 
Posts: n/a
Default size of data validation dropdown list

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