2 Letter Uppercase Entry Only

[xjohnson]

Hello,

Is there code to only allow to 2 letter entries in a column and keep them uppercase? This is for US States.

Thank you,
XJ

[dmcgov]

try this:

Please Login or Register  to view this content.

note that there is no state validation as you didn't ask for that. additional code is necessary to achieve that.

[xjohnson]

Thank you for the code.

It keeps popping up with message and can't get out. One popup to to next one.

[TMS]

Try this:

Please Login or Register  to view this content.

[dmcgov]

where did you put the code? (it should be the codesheet that you are working on column A).

i have tested the code and it does everything that you asked

[xjohnson]

Thank you TMS that works better. It functions without any popups. I also appreciate the help from you dmcgov.

Cheers!

[dmcgov]

@tms, can you look at my code and see what i did wrong? it appears to run fine on my side without recurring popups.

[TMS]

@dmcgov: seems to work OK for me. Maybe it's because you've used a Selection Change Event handler and it asks for input when you select a cell and then validates it. My code is a Change Event handler, so it only validates data when it is input (in column A).

Perhaps it's just less intuitive forthe OP.

Horses for courses, I guess.

[TMS]

@xjohnson: You're welcome. Thanks for the rep.