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

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

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