Hi All,

Is there any limit for number of items to place in data validation list?
Since I tried with 90 items to assign in datavalidation list but I couldn't.

Please share your thought or ideas.

Advanced Thanks,
Vinod

I just created a DV List with 10,000 items with no difficulty. Perhaps more
information on your setup is necessary.
--
John C


"Vinod" wrote:

Hi All,

Is there any limit for number of items to place in data validation list?
Since I tried with 90 items to assign in datavalidation list but I couldn't.

Please share your thought or ideas.

Advanced Thanks,
Vinod

If you create a delimited list, by typing the entries in the Data
Validation dialog box, the limit is 255 characters.

If you need a longer list, you could enter the items on a worksheet,
name the range, then refer to that named range. There are instructions he

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

Vinod wrote:
Hi All,

Is there any limit for number of items to place in data validation list?
Since I tried with 90 items to assign in datavalidation list but I couldn't.

Please share your thought or ideas.

Advanced Thanks,
Vinod


--
Debra Dalgleish
Contextures
www.contextures.com/tiptech.html
Blog: http://blog.contextures.com