How do i do this

When a user exits or tabs from TxtAddress to txtPhone

the value or string in TxtAddress will change to uppercase if not
already

I don't know how to go further on coding this


Sub TxtAddress_Exit()

format(TxtAddress,"Uppercase") - this obviously doesn't work

any help would be great, thank you for your time
Josh


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

Sub TxtAddress_Exit()

TxtAddress.Text = Ucase(TxtAddress.Text)

--

Regards,
Tom Ogilvy


"jhahes" wrote in
message ...

How do i do this

When a user exits or tabs from TxtAddress to txtPhone

the value or string in TxtAddress will change to uppercase if not
already

I don't know how to go further on coding this


Sub TxtAddress_Exit()

format(TxtAddress,"Uppercase") - this obviously doesn't work

any help would be great, thank you for your time
Josh


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

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