VBA date USA style not UK style

[fastcar]

Hi All,

I am using the following code to *** 15 lines with date, start and end time to an excel sheet.

The issue I have is that if I enter a date of 10/02/2023 un the box it will change it to 02/10/2023 on the worksheet.

I require the date to be as entered, in the UK format of dd/mm/yyyy

Please Login or Register  to view this content.

Thanks

[rorya]

Use CDate:

Please Login or Register  to view this content.