View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jason Gatsby Jason Gatsby is offline
external usenet poster
 
Posts: 4
Default Abort or continue

try this... may be easier than another window / form...

..
..
..
Dim i_Rtn as Integer

i_Rtn = MsgBox("what do you want to do?", vbYesNoCancel +
vbQuestion + vbDefaultButton2, "MyAppName")

' Check the MsgBox return code.
Select Case i_Rtn
Case vbYes
' Continue running code
Case vbNo
' Stop running code
Case vbCancel
' Cancel the whole thing, and the user will start
again later
End Select
..
..
..


-----Original Message-----
how do you have the option in code to have a popup that

will let you
continue or quit a code
what I am trying to do is when someone checks a

checkbox, is to give them
the option to continue or quit before the rest of the

code runs


.