Thread: Stop Macro
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
pete3589[_3_] pete3589[_3_] is offline
external usenet poster
 
Posts: 1
Default Stop Macro


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