Comments:
From your description you are having a problem running a macro when it is linked to real-time data. To run a macro when real-time data changes you need to use VBA’s OnData method. It will run a macro when real-time data changes.
For a detailed explanation I suggest you read the Willow Tips 2001-10 and download the mini-app. It is used to collect tick data but you can modify it to suit your purposes. You need to turn OnData on and off with a Boolean structure. This is explained in detail in the mini-app. The code is open and can be copied.
Also, OnData is discussed in some of the other Willow Talk questions and replies.
Hope this helps.
|