major issue with dates

[jpruffle]

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.

[shg]

Please take a few minutes to re-read the forum rules, and then start a new thread with a descriptive title.

Thanks.