Hi There,
I have a userform and need to use long date.
I am using 2010, cant get a calendar control so i am using a text box is there a way i can force long date (Wednesday, 10th June 2014)
Thanks,
Gordon
Hi There,
I have a userform and need to use long date.
I am using 2010, cant get a calendar control so i am using a text box is there a way i can force long date (Wednesday, 10th June 2014)
Thanks,
Gordon
set the text box property set format = "Long Date"
Do you want them to input it that way, or just display it so after they have entered the date?
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
MsgBox FormatDateTime(Date, 1)
thanks very much. That seemed to work well however i wish it to convert the date to a long date on the word doc that the userform is linked to