Now I see that in the subject. another example of why it is best to include
all pertinent information in the body.
Private Sub Textbox1_AfterUpdate()
Textbox1.Text = format(Textbox1.Text,"dd/mm/yy")
End Sub
You might have to experiment with other textbox events to see which works
best.
--
Regards,
Tom Ogilvy
"funkymonkUK"
wrote in message
...
unfortunately I cannot as I am using a userform.
--
funkymonkUK
------------------------------------------------------------------------
funkymonkUK's Profile:
http://www.excelforum.com/member.php...o&userid=18135
View this thread: http://www.excelforum.com/showthread...hreadid=414234