Yes or No MsgBox in VBA Macro

[Grimm127]

Hi all you wonderful Guru's,

I have a Macro with several calls within. How do I place a message box in before the last call to either yes run the last call or no to end the macro right there?

Call Macro1
Call Macro2
pop up a msg box yes or no to either continue to the next call or end the macro
Call Macro3

Thanks in advance

 

[jon1315]

Hi

How about something like:

Dim answer as string

Call Macro1
Call Macro2
Answer=(msgbox "Run macro 3?" ,vbyesno)

If answer=vbyes then
call macro 3
end if

 

[Fluff]

How about

Call Macro1
Call Macro2
If MsgBox("do you want to continue?", vbYesNo) = vbNo Then Exit Sub
Call Macro3

 

[jon1315]

Hi

How about something like:

Dim answer as string

Call Macro1
Call Macro2
Answer=msgbox( "Run macro 3?" ,vbyesno)

If answer=vbyes then
call macro 3
end if

Don't know how to edit a post but my bracket was in the wrong place!

 

[Grimm127]

How about

Call Macro1
Call Macro2
If MsgBox("do you want to continue?", vbYesNo) = vbNo Then Exit Sub
Call Macro3

Perfect Thank you!

 

[Fluff]

Glad we could help & thanks for the feedback.