View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Karen Agostinho Karen Agostinho is offline
external usenet poster
 
Posts: 2
Default UpCase in userform

Good Morning NG,
I have a text box that I receive user input for states.
I have the MaxLenght set to 2 so only things Like CA, NV, AZ can entered,
but sometimes the user wants to put in ca, nv, or az.
How can I set the text box to automatically capitalize the letters for the
users in VBA code
Thanks

Karen