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?

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?