Add "Are you Sure? YES NO" to Macro

[Bret1]

How can I make my Macro add a pop-up box "Are you sure? YES NO" before the Macro runs, and require "YES" selection to run?

 

[dmt32]

Hi,
you can add the following code in appropriate place in your code which may do what you want?

If MsgBox("Are You Sure?", 36, "Confirm") = vbNo Then Exit Sub

'rest of code

Dave

 

[Fluff]

Put this at the beginning of the sub

   If MsgBox("Are your sure?", vbYesNo) = vbNo Then Exit Sub

 

[Yongle]

one way

Sub YesOrNo()
    If MsgBox("Are you sure", vbYesNo, "User confirmation") <> vbYes Then Exit Sub
    MsgBox "Sub is running"
    'rest of code to run the sub goes here
End Sub

 

[Yongle]

what a boring thread - suggestions are too similar

 

[dmt32]

what a boring thread - suggestions are too similar

Great minds think alike perhaps!

Dave

 

[Bret1]

Thanks!

 

[Fluff]

Glad we could help & thanks for the feedback