Message Box: Continue with Macro or cancel process

Hi all,

I have a workbook that contains a macro that completes a process then clears all information from the workbook. I want to insert a message box that comes up first when the macro is run, that informs the user that running the macro will clear the workbook. If the user chooses "Yes", then the macro will continue to run, clearing the workbook in the process.

The user might not have realized that the macro will clear all of the data, and may wish to look over the data before it gets deleted. If the user clicks "No", then the macro will stop and not run the rest of the program. Is this something that can be easily done? I think I can get the macro to continue running if "yes" is selected, but I'm clueless about how to make it stop running if the user chooses "no".

Thank you for taking the time to read my question.

Thank you, MarvinP. I looked around on the Microsoft site for awhile, and then came up with a solution to my problem. I wanted my macro to continue processing if the user clicks "Yes", but to do nothing if the user clicks "No". I was hoping to find some code that makes the macro stop running when entered - it doesn't pause the macro but just ends the program right then and there. This way, if the user clicks "no" in the message box, the macro won't continue to run and delete all the data in the workbook. It will simply stop itself there.

My solution isn't complicated, but I just decided to create a separate macro for the message box. Using an IF statement, if the user selects "Yes", then the macro will continue to run by calling the original macro

Call Macro12

If the user selects "No", (else) the macro will simply select an active cell in the workbook and end the program, deleting no content.

Again, thanks to MarvinP for the direction.