Input Box Exit Sub If Not Date or When Cancel is Selected.

[ajlcpa]

Hi Folks:

I can handle this if I Dim the variable as a string, but I really need to Dim it as a Date. I want to exit the sub if a date is not entered or if Cancel is selected.

Thank you for reading and your help.

 Dim DateEntry As Date
    
   
   DateEntry = InputBox("Please enter the oldest start date using this format MM/DD/YY", "Date Selection")

 

[Akuini]

Do you want to take a shot at helping me sort? Or should I start a new threads

If t's a different problem than please start a new thread.

 

[ajlcpa]

If t's a different problem than please start a new thread.

Will do, if needed. I actually found the code I was looking for. Thank you again.