Sorry for the confusion...

I'm wanting them to only be able to enter 3 "Letters". _No_numbers_,
_no_spaces_, _no_special_characters_.

I want the end result to be all uppercase letters ("ABC"), not
lowercase, or mixed. If it is possible, I would like it to take
whatever they enter (Uppercase, Lowercase, or mixed) and change it to
uppercase (ex: Abc to ABC, or abc to ABC) as well as reject all entries
with spaces, numbers, or special characters.

Thanks to both of you for your help. Ron Rosenfeld, I tried your
private sub and it works great. My only thing is that it still allows
entries like 'A12' or 'a 1'. However, I think this will accomplish
what I am looking for.


The next thing I was wanting to do was put a drop down calendar on this
sheet. The odd thing that I want is to only show only Saturdays on the
calendar. For example, this month's calendar would have: June 4 2005,
June 11... June 18... and June 25.

I'm not sure if this is even possible.


Thanks for all your help already (to both Rons!!), and I really
appreciate your help with this next issue.


--
DejaVu
------------------------------------------------------------------------
DejaVu's Profile: http://www.excelforum.com/member.php...o&userid=22629
View this thread: http://www.excelforum.com/showthread...hreadid=380117