yes / no to continue macro

JAYLO · Apr 26th, 2002, 09:39 AM

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

AJ · Apr 26th, 2002, 09:46 AM

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 · Apr 26th, 2002, 09:47 AM

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

Apr 26th, 2002, 09:47 AM	#3
Ricky Morris Board Regular Join Date: Mar 2002 Posts: 363	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 __________________ It's never too late to learn something new. Ricky

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 26th, 2002, 09:39 AM	#1
JAYLO Board Regular Join Date: Apr 2002 Posts: 210	Is there a way to bring up a yes / no box to stop or continue a macro?

Apr 26th, 2002, 09:46 AM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	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