Hello again,
I have a lengthy existing macro that I want to add an if statement to at the very beginning. If the cell a53 is blank, I want the macro to run all the way through, but if cell a53 is not blank, I want a message box to appear asking the user if they are sure they want to continue.
I tried this:
If Range ("A53") <> "" Then
If MsgBox("The message box below is finding errors in the data entry, are you sure you want to continue?", 36, "SURE?") = vbNo Then Exit Sub
End If
and then the rest of my code
As usually, I did not work for me. I am pretty sure this is a simple one, but I don't seem to get it.
Mark
I have a lengthy existing macro that I want to add an if statement to at the very beginning. If the cell a53 is blank, I want the macro to run all the way through, but if cell a53 is not blank, I want a message box to appear asking the user if they are sure they want to continue.
I tried this:
If Range ("A53") <> "" Then
If MsgBox("The message box below is finding errors in the data entry, are you sure you want to continue?", 36, "SURE?") = vbNo Then Exit Sub
End If
and then the rest of my code
As usually, I did not work for me. I am pretty sure this is a simple one, but I don't seem to get it.
Mark
