You're welcome, and time spent learning something new is usually a good
investment!

Upya wrote:
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




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