Validation drop down list -- adding more rows to view

[Ormus]

Using Excel 03

Is there a way to add more rows to view to the drop down list from the data - validation? It currently shows 8 rows at a time.

Thanks

 

[VoG]

You could use a combobox http://www.contextures.com/xlDataVal14.html

 

[Ormus]

I will give it a try, thanks