Userform date format reverting back to us format on change event

Hi I have created a userform but I am having extensive problems with the date formats.

My system is set to UK and short date is set to: DD/MM/YYYY

When I used code to add the values in the userform to the spreadsheet, any that contained a date format would revert to the US format.

So I finally figured out to use DateValue to format it correctly for example:

Please Login or Register  to view this content.

This adds the data in the correct format. However when I retrieve the information using a change event for example:

Please Login or Register  to view this content.

They return UK formats if the month is less than 12 then revert to US if the date exceeds 12???????

I have tried alsorts to try and rectify it but I am really struggling can anyone offer me some advice please?

Thank you in advance.

If your cells are formatted to display the dates as you want, then you can just use:

Please Login or Register  to view this content.