VBA Code to End a Macro

[AlexGuest]

Hello. I'm trying to add a Message Box (with Yes and No buttons) to the beginning of a Macro that will ask the user to confirm if they want to continue. The code below works but I wanted to see if there is more efficiant code or "best practices" I should be considering.

Thank you

Sub Continue_With_Macro()

YesNo = MsgBox("This macro will ... Do you want to continue?", vbYesNo)
If YesNo = vbNo Then Exit Sub
ACTUAL MACRO/CODE STARTS HERE

End Sub

 

[jproffer]

There are other ways (all basically the same though), but one isn't any more efficient than another IMO.

 

[mvptomlinson]

That's pretty much standard, it's what I would use. You could reverse it, but either way works.

Sub cwm()
YesNo = MsgBox(.........)
If YesNo = vbYes Then
' do your macro
End If
End Sub