How to create a yes no message box before running a macro in Excel?
In Excel, you can directly trigger a macro by pressing the F5 key or click the Run button in the Microsoft Visual Basic for Applications window. But, sometimes, you may want to create a message box that will ask the user if they want to run the macro. If yes, then continue running the code, if no, stop running the code. This article, I will talk about how to create a yes no message box before running a macro in Excel.
The following VBA code can help you to add a yes no prompt box to confirm if running a macro, please do with below steps:
1. Hold down the ALT + F11 keys to open the Microsoft Visual Basic for Applications window.
2. Click Insert > Module, and paste the following macro in the Module Window.
VBA code: Create a yes no message box before running a macro:
Sub continue() CarryOn = MsgBox("Do you want to run this macro?", vbYesNo, "Kutools for Excel") If CarryOn = vbYes Then 'put rest of code here End If End Sub
Note: In the above code, please copy and paste your own code without the Sub heading and End Sub footer between the If CarryOn = vbYes Then and End if scripts. See screenshot:
3. Then press F5 key, a prompt box will pop out to remind you if you want to run this code, click Yes button to continue, and click No to stop, see screenshot：