Is there a way that I can interrupt some code, at whatever stage it was at
when a button is clicked and then resume where it left off by clicking
another button. I would like to do this in real-time not in debug mode.
Thank you

What do you want to do within this interrupt?


--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ben" wrote in message
...
Is there a way that I can interrupt some code, at whatever stage it was at
when a button is clicked and then resume where it left off by clicking
another button. I would like to do this in real-time not in debug mode.
Thank you

Stop - might be the answer? But depends what you want to do?

--

Regards,
Nigel




"Ben" wrote in message
...
Is there a way that I can interrupt some code, at whatever stage it was at
when a button is clicked and then resume where it left off by clicking
another button. I would like to do this in real-time not in debug mode.
Thank you

Let's say for instance that the program is sequentially processing 100 rows
and prodiucing a result for each row in col Z.
Supposing I want to interrupt the program at some stage in order to inspect
the results thus far and then resume the processing of the remaining rows at
a later stage..... much like using a break point in debug mode and then
resuming the execution of the program.

"Nigel" wrote:

Stop - might be the answer? But depends what you want to do?

--

Regards,
Nigel




"Ben" wrote in message
...
Is there a way that I can interrupt some code, at whatever stage it was at
when a button is clicked and then resume where it left off by clicking
another button. I would like to do this in real-time not in debug mode.
Thank you

You could use Application.Inputbox(msg, Type:=8), and just ignore the
return.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Ben" wrote in message
...
Let's say for instance that the program is sequentially processing 100
rows
and prodiucing a result for each row in col Z.
Supposing I want to interrupt the program at some stage in order to
inspect
the results thus far and then resume the processing of the remaining rows
at
a later stage..... much like using a break point in debug mode and then
resuming the execution of the program.

"Nigel" wrote:

Stop - might be the answer? But depends what you want to do?

--

Regards,
Nigel




"Ben" wrote in message
...
Is there a way that I can interrupt some code, at whatever stage it was
at
when a button is clicked and then resume where it left off by clicking
another button. I would like to do this in real-time not in debug mode.
Thank you