How can I formate the date in a text box on a user form.

[aysam]

Hi all
How can I formate the date in a text box on a user form.
I want the date to appear as follow:
yyyy/mm/dd
Thanks in advance

[p45cal]

cross post http://www.mrexcel.com/forum/showthread.php?t=626158

[CatDaddy]

Format(Date, "yyyy/mm/dd")

[aysam]

Sorry for the cross posting
===================
thanks CatDaddy
but would you please give some more details????

[CatDaddy]

post your code