Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
halting macro
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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
halting macro
For example
IF Msgbox("Continue?",vbYesNo,"Pause")=VBNo Then Exit Sub End If Patrick Molloy Microsoft Excel MVP -----Original Message----- 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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
halting macro
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 -----Original Message----- 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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
halting macro
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 -----Original Message----- 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 *** Sent via Developersdex http://www.developersdex.com *** Don't just participate in USENET...get rewarded for it! . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro recorded... tabs & file names changed, macro hangs | Excel Worksheet Functions | |||
Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) | |||
Macro needed to Paste Values and prevent Macro operation | Excel Discussion (Misc queries) |