Thanks for you response,

Someone told me data validation was case sensitive by default, but I
couldn't work it out for love or money.

So I just spent 3 hours working out how to change in VBE to make text
in given cells automatically upper case.

Only to read your response to find out that if I typed the 3 variables
seperated by a comma instead of highlighting my list, it would be case
sensitive (when highlighting a list or using a defined name list - it
was not case sensitive).


Oh well, it was fun trying to figure it out, hehehe

Thanks again for your help :D


--
Upya
------------------------------------------------------------------------
Upya's Profile: http://www.excelforum.com/member.php...o&userid=27889
View this thread: http://www.excelforum.com/showthread...hreadid=473917