Hi all...new to the forum.

I am converting an Excel program that used DDE to communicate to a DDE server (RSLinx) to OPC and I have the communication working.

In the DDE version, I used the Worksheet_Calculate() function to look for data changes and I would trigger different functions when certain cells would change from 0 to 1. The cells had a direct reference to the DDE server by using =DDEServer|TopicName!Address while the cell values in the new OPC version all get filled through VBA and I think this is why the Worksheet_Calculate function is not responding to the changes.

Is there another method I can use to look for data changes so that I can execute my functions?