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.


--
jimbo_jones
------------------------------------------------------------------------
jimbo_jones's Profile: http://www.excelforum.com/member.php...o&userid=27244
View this thread: http://www.excelforum.com/showthread...hreadid=469034

Hi Jimbo,

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

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

--
Regards,

Juan Pablo González
Excel MVP

"jimbo_jones"
wrote in message
...

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.


--
jimbo_jones
------------------------------------------------------------------------
jimbo_jones's Profile:
http://www.excelforum.com/member.php...o&userid=27244
View this thread: http://www.excelforum.com/showthread...hreadid=469034

Thanks! This works perfect!!


--
jimbo_jones
------------------------------------------------------------------------
jimbo_jones's Profile: http://www.excelforum.com/member.php...o&userid=27244
View this thread: http://www.excelforum.com/showthread...hreadid=469034