UK vs US Date Format in User Form

Hello

Having an issue with the date in a UserForm Txt field, displaying US Date format.
For this example, I use these test dates: a) 2 Mar 2013 and b) 13 Mar 2013

Worksheet
Column8: LDATE
Format (UK date format): d/mm/yyyy

UserForm (purpose:to edit records on the ws)
Field: txtLDATE
Poulated from LDATE in ws.

The date is pulled from the ws to the userform with this code:

Please Login or Register  to view this content.

If I don't have the 'with' section of the code, the date comes into the UserForm in US date format, as so:
a) 3/2/2013
b) 3/13/2013

and I thought I had resolved that with the addition of the 'with' section of the code - however , no - it's only a half-solution:

This is the problem:

If I have the 'with' section of the code, only dates with a day from 13th to the 31st format as UK date.
Any date from the 1st the the 12th day, format as US date. As so:
a) 3 Feb 2013 (wrong)
b) 13 Mar 2013 (right)

If instead of the 'with' section of code, I have EITHER of the following lines - the result is just the same:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

And it makes no difference what the dateFormat is on the ws - whether it's the exact same format
as in the code for the UserForm or not.

If anyone could help me reslove this, i would be most grateful! I have searched for solutions but can't seem to find anything.

Cheers
Annieb

Try using the .Value2 property from the cell. It's the unformatted serial date value.

Please Login or Register  to view this content.