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.
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.
VBA Code:
Dim DateEntry As Date
DateEntry = InputBox("Please enter the oldest start date using this format MM/DD/YY", "Date Selection")