View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Nils Magnus Nils Magnus is offline
external usenet poster
 
Posts: 10
Default 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