If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Unanswered: Restrict Cell Entry to Y or N

With an Excel 2003 data validation list of "Y,N", can I use the data validation function to accept lowercase 'y' or 'n' but change lowercase letters to uppercase if needed? Or should I accept all 4 values and use VBA with the sheet's Change event to uppercase the values?
Jerry

The latter choice of the two. I normally only allow upper case and in the data validation message box, I explain that entries must be upper case. The users catch on and it saves me having to use VBA for it.