VBA - Change inputBox date from US to UK standard (mm-dd-yyyy -> dd-mm-yyyy)

[Nozon]

Hello

I've been searching a bit and seems like there's no real answer to this.

As it is I can add the date (dd-mm-yyyy), but it won't see it as a date before I manually press enter on the cell. Problem is when another macro afterward search for the latest date and won't detect that cell as a date, if not manually entered on the cell.

(Yes, it is due to the american standardization this problem occur, because if the day is below 12 it will swap place between day and month (which is a problem in itself))

Best regards
Nozon

 

[steve the fish]

Presuming your local date setting is dd/mm/yyyy then try somthing like this:

x = InputBox("Enter Date in format DD-MM-YYYY")
Range("A1") = CDate(x)

 

[Nozon]

Presuming your local date setting is dd/mm/yyyy then try somthing like this:

x = InputBox("Enter Date in format DD-MM-YYYY")
Range("A1") = CDate(x)

Thanks a lot. Works fine now