Dear,

You can write the following code in textbox of date.

Private sub txtdate_afterupdate()

with txtVdate

..value = Formate (.value, "dd/mm/yyyy")

End with

End sub


--
Syed Haider Ali
------------------------------------------------------------------------
Syed Haider Ali's Profile: http://www.excelforum.com/member.php...o&userid=21994
View this thread: http://www.excelforum.com/showthread...hreadid=392257