Enter the values on a worksheet, then refer to that range in the data
validation dialog box. There are instructions he

http://www.contextures.com/xlDataVal01.html

Roger wrote:
When entering my data for a drop down menu, I'm being limited to only half
the entries I need to make. Is thera a way to change the properties to allow
more entries?


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html