VBA MsgBox code needed for skipping portion of code

[dwilliamson1024]

Good afternoon everyone.

I need to put in a pop up box in my VBA code to have it ask the user if they want to do something. They can click Yes or No
Yes: continues as normal
No: skips a section of the code

I did a few tries at this and keep getting an error. I know this is simple. Can someone please help me?? Thanks!!

 

[jtakw]

Try this:

Continuewiththis = MsgBox(Prompt:="Do you want to continue with this?", Buttons:=vbQuestion + vbYesNo)
    If Continuewiththis = vbNo Then GoTo Skipthispart
'your code doing something
'end of your code doing something
Skipthispart:
'more of your code
'or end of Sub

 

[dwilliamson1024]

Thanks, I'll give that one a shot and let you know....!

 

[dwilliamson1024]

It worked beautifully. Thank you!

 

[jtakw]

Glad it worked, and you're very welcome.