Yes no textbox urgent

[TurboDieselOne]

Hi
I need a way so that a person can only type yes or no in to a text box and then when it tabs to the next text box it turns to ucase. I know the onexit ucase(Variable) but the if me.Texbox1.value = "YES" or "NO" does not seem to work. GOT a 6 Page userform full of yes no textboxes so I can use this code across the board.

Thanks in Advance

 

[TurboDieselOne]

I open the form close the form and then the msgbox appears I like the msgbox looks professional.

Thanks

 

[Mike Blackman]

How and when are you triggering this code?

 

[TurboDieselOne]

On exit on the Userform textboxes.

Iv'e "' out " the msgbox.