How to cancel a macro once started?
A one liner:
If MsgBox("Do you want to delete?", vbYesNo + vbQuestion, "Confirm Delete")
= vbNo Then Exit Sub
CE
John wrote:
I know nothing about VBA except the recorder and able to modify a bit.
I have a macro to erase a form that is activated with a button. I
would like to be able to
have a message to confirm the deletion (Msgbox ) but have the choice
to say no and stop the macro from erasing.
I would appreciate any help please
Thanking you in advance
John
|