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. If you don't like Google AdSense in the posts, register or log in above.

Data Validation List Accpet only Uppercase

I would like a data validation list to only accept an uppercase Y or N from the dropdown in a cell, but users can type a lowercase Ys and Ns and they are accepted. I would like the cell to only accept the uppercase Ys and Ns from the dropdown. Does this require code or is there a simpler way? Thanks!

Re: Data Validation List Accpet only Uppercase

Originally Posted by chris46521

Thanks. I tried this, but it still says accepts a lowercase N and Y. It must require VBA code.

Please look at the attached sheet. Unless there is some difference between Excel 2000 and Excel 2003, you must have something wrong - it definitely does NOT accept lower case in the attachment. Maybe some option needs switching.

Attached Files. REMINDER! OzGrid accepts no responsibility for ANY adverse effects as a result from downloading attached files. ALWAYS run an up-to-date virus scan and disable macros.