Interrupt While loop

[jimbo_jones]

I have a program that check a value for 1 min, I do this in a while
loop. What are some ways to exit the while loop while it's running?

I would like to have an E-Stop button on my form for the user, but I
don't know how to make the button work when a while look is going.
Thanks.

 

[Juan Pablo González]

Hi Jimbo,

If you put the DoEvents inside your loop, then you could use something
similar to this:

http://www.dicks-blog.com/archives/2005/06/14/stopwatch/

--
Regards,

Juan Pablo González
Excel MVP

"jimbo_jones" <[email protected]>
wrote in message
news:[email protected]...

 

[jimbo_jones]

Thanks! This works perfect!!