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.

Create a yes no message box before running a macro with VBA code

---

Create a yes no message box before running a macro with VBA code

---

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：

---

Recommended Productivity Tools for Excel