I have some VB code that reads about 20 tags from a PLC and communicate
through DDE. The code contantly collects data from these tags and lay
them out in excel. From there I use Lists to select which data colum
I want to read.

Everything works fine with my code except that once I start the macro
have no way of stopping it other than hitting ctrl + break. I woul
rather not have the users stopping the data collection this way but I'
not sure of a solution.

I want to use a stop toggle button , but I don't think I could push i
while the macro is running (the working hourglass is up).

Anyone have any solutions

--
pete358
-----------------------------------------------------------------------
pete3589's Profile: http://www.excelforum.com/member.php...fo&userid=2840
View this thread: http://www.excelforum.com/showthread.php?threadid=48394

Im sure someone has a solution to this.


--
pete3589
------------------------------------------------------------------------
pete3589's Profile: http://www.excelforum.com/member.php...o&userid=28402
View this thread: http://www.excelforum.com/showthread...hreadid=483944