Try adding a formula in the DV allow type of custom of

=EXACT(K1,UPPER(K1))

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)

"Ken" wrote in message
...
Excel 2003 ... I have a Data Validation List (& Switch) that is working
fine
(ALL UPPER Case in the List & Switch) ... However, entries can still be
made
from the keyboard ... Some folks are entering LOWER Case which Validation
is
accepting ...

Above said ... I wish to set Data Validation to accept only UPPER Case.

Can I do this? ... Thanks ... Kha