Need code to run when value referenced changes

Hello,

I need code to run when a cell’s referenced value changes, not when the cell content changes. In other words, the cell contains this formula, which doesn’t change:

=Telem|RealTime!‘Lap Number’

Each time the driver goes by the beacon, the lap number information is updated, and that is when I need the code to run. Since the actual content of the cell as shown above does not change, the code (I’m currently using Worksheet_Change) doesn’t run.

More detail: I am using DDE to populate the Excel spreadsheet, and what I am trying to record automatically is the lap time for each lap. The final desired result will look something like this:

Lap Lap time
1 128.29
2 127.33
3 128.40
4 127.01


I have code that records this information IF I enter something in the target cell, but I need it to recognize that the referenced value has changed and run automatically.

From what I’ve read, it appears as though I may be abel to use copy/pastespecial to paste the value into a cell, but I’m not sure of the code or where it would go.

Another option I wonder about is if there is a way to pass just the value in =Telem|RealTime!‘Lap Number’ to another cell in Excel and then have the code run based on changes to that cell.

Please advise. Any help is appreciated.

Thank you!