Date format in userform problem.

[PJS Soft]

I've got a userform that asks for a date it then stores that date in a sheet.
I then have an edit button which retrieves the information from the sheet back into the form.
Every time it copies the date back if the day is 12 or below it flips the date to US format.
The date is originally stored in the correct format but it won't return as UK format and will over write it back into the sheet as US format.

Any ideas?

 

[cstimart]

I've got a userform that asks for a date it then stores that date in a sheet.
I then have an edit button which retrieves the information from the sheet back into the form.
Every time it copies the date back if the day is 12 or below it flips the date to US format.
The date is originally stored in the correct format but it won't return as UK format and will over write it back into the sheet as US format.

Any ideas?

Try using...

Range("A1") = Format(d8, "dd/mm/yyyy")

 

[PJS Soft]

Just the trick thanks