Popup Box To Confirm Running A Macro

[tjeacret]

Hello gurus! I have a macro in my workbook that is set to clear all contents of several sheets. I would like to get a popup box to come up that says "Are you sure you want to clear the workbook?" with a Yes/No response. If Yes - Run the macro. If No - don't do anything. Can't figure it out. Thanks!

 

[VoG]

Try

If MsgBox("Are you sure you want to clear the workbook?", vbYesNo, vbQuestion) = vbNo Then Exit Sub

 

[tjeacret]

Do I put that in as the top line of the macro I'm trying to run?

 

[VoG]

Yep, probably. Pleas4e post your code.

 

[tjeacret]

Worked perfectly! VoG - you are awesome. You've helped me twice in the past two days with my workbook and I truly appreciate it. Thanks!