Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
stopping macro
I have a procedure macro that calls a dialog box. After
parameters are input, the user clicks an "Ok" button and the macro runs. At times the procedure can take a very long time to run. Is there a way to allow the user to break the macro and not wait until it finishes? I have only been able to use [CTRL][ALT][DEL] and end Excel, but obviously that is not a very good solution. I have tried to use the [ESC] key, but it just ignores the key press. Maybe a status dialog box with a cancel button? Anyone used anything they feel works well? Thanks in advance, Dave |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
stopping macro
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
stopping macro
Thanks!
-----Original Message----- you can try ctrl+break, it should work. --- Message posted from http://www.ExcelForum.com/ . |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
stopping macro
I do use a stop button on a status form in some of my macros
When a user presses the stop button, code attached to the stop butto sets a public boolan variable. At strategic places through out my code i place code to check if th variable is true or false taking action as required To prevent the macro from hanging waiting for user input when th status form is activated i use Private Sub UserForm_Activate() call mymacro End Su -- Message posted from http://www.ExcelForum.com |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protect macro from stopping | Excel Discussion (Misc queries) | |||
Stopping Excel macro pattern recgonition | New Users to Excel | |||
Stopping an animation macro | Excel Programming | |||
My Macro keeps stopping?? | Excel Programming | |||
Stopping a macro without using Ctrl Break | Excel Programming |