yes / no to continue macro

[JAYLO]

Is there a way to bring up a yes / no box to stop or continue a macro?

 

[AJ]

A simple message box should do the trick, i.e.

Sub continue()

CarryOn = MsgBox("Do you wanna carry on?", vbYesNo, "Continue?")

If CarryOn = vbYes Then
'put rest of code here

End If

End sub

 

[Ricky Morris]

Sub Yes_No_Msg()
ans = MsgBox("Your Question Here?", vbYesNo)
If ans = vbYes Then
'Yes your code here
Else
'No your code here
End If
End Sub