Hi

Using Data Validation, you can't. The size is fixed at 8 lines.
If you want to have more, you will need to use a Combo Box.

Instructions can be found at Debra Dalgleish's site
http://www.contextures.com/xlDataVal10.html

--
Regards
Roger Govier



"Swill_Vermin" wrote in message
...
I'm trying to work out how to increase the length of a dop down list
within
an excell 2003 worksheet, or in other words how do I get the drop down
list
to display more data (approx 30 options) without having to scroll through
those options within the drop down menu.

Any ideas?