How to interrupt code

[Ben]

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

 

[Bob Phillips]

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)

 

[Nigel]

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

 

[Ben]

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.

 

[Bob Phillips]

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)