VBA User form - UK Date Entry converts to USA Date Format

[reelspike]

Hi,

I've created a userform with one of the text boxes to be used as a date entry. I am UK based and so use the format dd/mm/yyyy. However, whenever I send data from the userform to the data table, the date gets converted to US date format.

So, for example, day is 10th January 2024 - enter in userform as 10/01/2024. The date in the data table is shown as 01/10/024 - which is 1st October 2024!

I have seen plenty of examples online of this, and attempts to resolve this - but nothing seems to work for me! I am a very basic user!

Does anyone have any suggestions as to how to fix this?

 

[Alex Blakenburg]

Try using Range(TheDestination) = CDate(UserformValue)