If you create the list by typing the values in the Data Validation
dialog box, the entries will be case specific.

If you refer to a list on a worksheet, the entries will not be case
specific. There are instructions here for referring to a list on a
worksheet:

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


Kevin wrote:
Hi

I have created a data validation list. If user types value instead of
selecteing from drop down does user always have to enter case specific.

Eg list is "Y" and "N". user cannot type "n"


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