Date always reverts to American format in Userform

Hi,
to read a date from your range in to a textbox and kept its format, use the Range.Text property.

Please Login or Register  to view this content.

this should return what you see in the cell.

Dave

Thanks both for the input.

Winon, I didn't understand every part of the code you linked to but I tried the following:

Please Login or Register  to view this content.

Needless to say I failed! Is that as lame an attempt as I suspect it was on my part?


Hey dmt32, that is actually very helpful - Can't actually tell if it works yet because my userform is now putting all data into the spreadsheet as mm/dd/yyy to begin with so that obviously going back the other way it is still in the wrong format.

Problem is my

Please Login or Register  to view this content.

code has started throwing up mismatch errors so I scrapped it and I'm back to square one!

Originally Posted by henryBukowski

Dear all,
I have a problem with american date formats always reoccuring. I have seen other posts on this problem but none matching my particular issue.

I have a userform in which my users enter data which is then added to the excel spreadsheet.
Sometimes they need to amend this data so we have made their data editable - it gets put back into the userform so that changes can be made.

The issue is with dates. These are entered as dd/mm/yyyy but when they are then added to the userform they always go back to mm/dd/yyyy

The code to put the userfrom data to the spreadsheet is as follows:

Please Login or Register  to view this content.

...Then to put it back into the form for editing:

Please Login or Register  to view this content.

I made some progress by specifying instead of the first line:

Please Login or Register  to view this content.

Using DataValue or CDate. This works to an extent because data is now added in the format dd/mm/yyyy - hooray!

However, when put back into the userform it still goes back in the form mm/dd/yyyy!!!!

Is there a way I can override this American date format which keeps coming back?

Many thanks in advance

Henry

Linked: http://www.mrexcel.com/forum/excel-q...ml#post4592462

All you have to do is format the date from the cell with the format you want on load or however you activate it like so:

Please Login or Register  to view this content.

Let me know if this is what you want.