Thread: Uppercase a text box
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
anilsolipuram[_41_] anilsolipuram[_41_] is offline
external usenet poster
  
Posts: 1
Default Uppercase a text box

I am assuming that TxtAddress is name of textbox, which when pressed
tab key will change text to uppercase.

Private Sub TxtAddress_Exit(ByVal Cancel As MSForms.ReturnBoolean)
TxtAddress.Value = UCase(TxtAddress.Value)
End Sub


--
anilsolipuram
------------------------------------------------------------------------
anilsolipuram's Profile: http://www.excelforum.com/member.php...o&userid=16271
View this thread: http://www.excelforum.com/showthread...hreadid=377462

Reply With QuoteReply With Quote