Hi,
In A column, I have dates that were put in with a macro then formatted m/dd/yyyy . No dates anywhere else.

I’m trying to have an input box find a date and use a message box on an error
This macro will find the date if the input is in the proper format but the error box will come up anyway. The macro ends with either choice (yes/no)
If there is an error (wrong format or no date, the error box comes up and the macro ends with either choice (yes/no)

If no date, I’d like a message box to say so and ask for another try or end
If wrong format, I’d like the input to change to the proper format, or an error box coming up to change the format

If no error, I don’t need an error box
HTML Code: 
Mike