halting macro

[Jonas O]

Hi again,
lots of questions from here and thanks for all the good answers! Really
helped.

Another question is how to make a dialogbox where you answer a question
(yes or no answer) were a positive answer would continue to run the
reminding macro while a negative answer would halt the macro right
there.

Is there such an code to resolve this as well?

Kind regards

Jonas

 

[Patrick Molloy]

For example

IF Msgbox("Continue?",vbYesNo,"Pause")=VBNo Then
Exit Sub
End If

Patrick Molloy
Microsoft Excel MVP

 

[Leyton]

Jonas

If you use the built in msgBox dialog:

Sub test()
Dim iResult As Integer

iResult = MsgBox("Do You want to continue?",
vbYesNo, "Test")
If iResult = vbNo Then
Exit Sub
End If
' Do the rest
End Sub

Note that vbYes, vbNo (and the others) all return an
integer value which you can test for or use the constants
as above

HTH

Leyton

 

[Esco]

Here is an example.

sub Test()
dim usrchoice
usrchoice=msgbox("Do You want to continue?",vbyesno)
if usrchoice=vbno then end
msgbox "To be continued..."
end