force long date

[runningpiema]

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

[ranman256]

set the text box property set format = "Long Date"

[Bob Phillips]

Do you want them to input it that way, or just display it so after they have entered the date?

[snb]

  MsgBox FormatDateTime(Date, 1)

[runningpiema]

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