Data Validation Drop Down Query

Hi All
Would anyone know if it is possible to extend the size of the list presented when using the data validation drop down? At present, it seems to default to 8 choices (even though there is a scroll bar) but I was wondering could the list automatically display, say 20 choices?

Many Thanks
Shytott

Hi
Shytott
ion the validation list add the range of the list you require
list = (A1:A100)

Originally Posted by Shytott

At present, it seems to default to 8 choices (even though there is a scroll bar) but I was wondering could the list automatically display, say 20 choices?

No I'm afraid not. You would need to use an alternative method (ie a control) - http://www.contextures.com/xlDataVal10.html