ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Abort or continue (https://www.excelbanter.com/excel-programming/273527-abort-continue.html)

Jason Gatsby

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


.



All times are GMT +1. The time now is 05:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com