Data Validation Pick List Box size?

[orestar]

I need help on how to enlarge the list of data that a "data validation" box allows. It is currently 8 rows that are allowed now. I know I can enlarge the number of rows visible for a combo box in "combo box properties" but i would like to do it for the data validation Pick list.
Thank you for your help

 

[xlbo]

AFAIK there is no way to change this

Rgds, Geoff
Quantum materiae materietur marmota monax si marmota monax materiam possit materiari?
Want the best answers to your questions ? faq222-2244