Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button on Userform to Stop a Macro
I've created a simple add-in with code that loops through a large range of
data. I would like to add a button to the userform that allows the operator to stop the macro at any time. Is there code or a command that I could include in a button-click event that would allow the user to stop the macro? -- Steph |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button on Userform to Stop a Macro
Why not just teach them to use Ctl + Break? Or build in a break point in
your code that they can then restart. VBA does not lend itself to easily stopping and restarting at a user's convenience. "Steph" wrote: I've created a simple add-in with code that loops through a large range of data. I would like to add a button to the userform that allows the operator to stop the macro at any time. Is there code or a command that I could include in a button-click event that would allow the user to stop the macro? -- Steph |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Button on Userform to Stop a Macro
You may be able to find something here.
http://en.allexperts.com/q/Visual-Ba...s-Function.htm -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. "Steph" wrote: I've created a simple add-in with code that loops through a large range of data. I would like to add a button to the userform that allows the operator to stop the macro at any time. Is there code or a command that I could include in a button-click event that would allow the user to stop the macro? -- Steph |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to stop macro with cancel button | Excel Programming | |||
Stop macro with userform | Excel Discussion (Misc queries) | |||
Start/Stop Macro Button | Excel Discussion (Misc queries) | |||
Stop Macro button in Excel VB | Excel Programming | |||
Macro Record Stop Button | Excel Discussion (Misc queries) |