ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   stopping code (https://www.excelbanter.com/excel-discussion-misc-queries/205232-stopping-code.html)

jase

stopping code
 
I have a button that runs a series of subs. I sometimes need to quit running
the code in the middle of running it, to do this I just keep hitting excape
until i get a debug to end it. Is their a way that I could have a button
with code that would jump in and end right away? and if possible to tell me
at what sub I have eneded at?

thanks,

Jase

Mike H

stopping code
 
Hi,

Ctrl+Break and select 'Debug'

Mike

"Jase" wrote:

I have a button that runs a series of subs. I sometimes need to quit running
the code in the middle of running it, to do this I just keep hitting excape
until i get a debug to end it. Is their a way that I could have a button
with code that would jump in and end right away? and if possible to tell me
at what sub I have eneded at?

thanks,

Jase



All times are GMT +1. The time now is 04:11 PM.

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