If the list is short, you could type upper case entries in the Data
Validation dialog Source box. That would validate for upper case entries
in the cell.

If the list is a range on the worksheet, the data validation isn't case
sensitive. You could use programming to convert entries to upper case
after they're typed.

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


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