Timeouts on VBA code
Hello,
Is it possible to make VBA code time out after a while if it still
hasn't finished? I'm working on a simulation, and depending on the
parameters, it can sometimes keep on processing without ever reaching an
answer. I cannot know in advance what parameters give answers, and what
parameters don't.
What I would like is that if an answer hasn't been found in 10 seconds,
it should write "Inconclusive" or something similar in the result cell.
How can I do this, if it's possible?
Thanks :-)
Regards,
Nils Magnus
|