can't get error message box not to show if no error or to loop back to macro if there is a

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

If you want the message to be displayed for a Null String, then you need to trigger an error if it is a null string rather than exit the sub.

No need to trigger an error. You can just display messagebox when Null string then exit sub if needed.
Something like...

Please Login or Register  to view this content.

can use goto or error to allow using only one message box...that way if you want to change the message, you only need to change one.

Hi all,

I’m still self learning about macros. I made this macro by looking at excel help here and sites that don’t answer questions.
If the input is formatted correctly and the date can be found, the cursor will go to the proper date BUT the error message box also comes up. Either option in the box will close it.
If the input is formatted wrong or no date exists, the error message box comes up and again either option in the box will close it.
The date is put in with an open macro that uses

HTML Code: 

What I would like is if the input is formatted wrong or no date exists, and yes is clicked in the error message box, the input box comes up again to be tried again.

OR, an error message box comes up with why the date can’t be found and the input box comes up to try again.
I don't need the error box come up if the date can be found.
I noticed that somehow I made a mistake with the name of the macro I wanted called if the yes/no case in the error box is yes. “findqdate” shouldn’t have the “q” in it.

Here is the macro I’m trying to fix

HTML Code: