VBA- Enter date via Inputbox

[kgkev]

I'm struggling a bit with date formats, it seems what ever I try I get another problem.

I want to ask the user to input a date, I expect them to type the date in a UK format eg 31/12/2019 for new years eve.
I also want the user to have the option of leaving the inputbox blank

 CommDate = InputBox("Please enter due date", "Due Date")

If I declare CommDate as String then the input is swapped to USA format.
If I delcare CommDate as a date then I cannot leave the date blank.

Any advise is appreciated.

 

[RoryA]

Declare a string, then after testing that the result isn't "", assign it to a Date type variable using CDate.

 

[kgkev]

Cheers RoryA, thats nailed it!

 

[kgkev]

:IGNORE:
Had calcs turned off - it does work as expected