PDA

View Full Version : How can I formate the date in a text box on a user form.



aysam
04-03-2012, 03:03 PM
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
04-03-2012, 03:10 PM
cross post http://www.mrexcel.com/forum/showthread.php?t=626158

CatDaddy
04-03-2012, 03:20 PM
Format(Date, "yyyy/mm/dd")

aysam
04-05-2012, 02:32 PM
Sorry for the cross posting
===================
thanks CatDaddy
but would you please give some more details????

CatDaddy
04-05-2012, 02:43 PM
post your code