asked on Office VBA stop code execution via form
I would like some one to show me how to set up code and a form so that when the code is running, a stop command on the form will halt the running code nicely.
i have attached an example, just to show what I mean.
when you click run, it runs some code in the background. then what needs to happen is when stop is clicked, the code is stopped nicely in a way to branch to some closing code.
Userform-break-example.xls
i have attached an example, just to show what I mean.
when you click run, it runs some code in the background. then what needs to happen is when stop is clicked, the code is stopped nicely in a way to branch to some closing code.
Userform-break-example.xls
Visual Basic ClassicMicrosoft Excel
Last Comment
Curt Lindstrom
ASKER
thanks for the reply,
did you get this to work, as I can't?
the form doesn't break the code, just hangs when I try to press stop.
did you get this to work, as I can't?
the form doesn't break the code, just hangs when I try to press stop.
Strange, it exits the form immediately when I press the Stop button.
For more information in how to design a userform try the links to this website.
http://www.contextures.com/xlUserForm01.html
http://www.contextures.com/xlUserForm02.html
Cheers,
Curt
For more information in how to design a userform try the links to this website.
http://www.contextures.com/xlUserForm01.html
http://www.contextures.com/xlUserForm02.html
Cheers,
Curt
ASKER
okay, I believe you havent pressed the run button first.
the whole idea is to stop some running code.
the whole idea is to stop some running code.
Yes you're right! I didn't read your question properly :-)
I don't think it's possible to break the running code with a Stop button on the Userform. Your code calling the auto_open cannot even be stopped with Ctrl/break.
Try this one with two For loops. As you can see the Run button remains pressed during the execution of the code which means that no other buttons can be pressed on the form. You can however stop this code from running with Ctrl/break.
Curt
Userform-break-example-2.xls
Try this one with two For loops. As you can see the Run button remains pressed during the execution of the code which means that no other buttons can be pressed on the form. You can however stop this code from running with Ctrl/break.
Curt
Userform-break-example-2.xls
ASKER CERTIFIED SOLUTION
THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
ASKER
Genius, thanks, very handy to know.
Simple indeed.
Sometimes I just have to show my ignorance to keep learning something new :-)
Thanks for the lesson Ledigimate, Sorry for misleading you thydzik.
Curt
Sometimes I just have to show my ignorance to keep learning something new :-)
Thanks for the lesson Ledigimate, Sorry for misleading you thydzik.
Curt
See attached modified file
Curt
Userform-break-example-1.xls