End Macro on MsgBox Response

[Bnygren]

I know there's an easy way to do this but am drawing a blank. I want to add a msgbox to my code that, based on the user's response, will either continue the code or stop the macro.

For instance, have you completed this step? If user says no, msgbox prompts them to go do that first and come back. Then the macro jumps down to end.

Hope that makes sense.

Thanks,
Bob

 

[VoG]

Like this

Dim response As VbMsgBoxResult
response = MsgBox("Have you done step1?", vbYesNo)
If response = vbNo Then
    MsgBox "Please do that first"
    Exit Sub
End If
'rest of code

 

[Joe4]

How about something like:

    myResponse = MsgBox("Did you complete step 1", vbYesNo)
    If myResponse = vbNo Then Exit Sub

 

[Bnygren]

I knew it was easy!!

Thanks for your help.