DDE Link and VBA question (simple I think)?

[ohgeesh]

So, simple I can't figure it out.

1. I have a Cell A1 and if I type a value in it say 4 enter, 6 enter, 98 enter
2. The value is copied to another sheet C1 increment down a row on value changed and timestamped.
3. Essentially so I can see when the value changes and what time.

Now the problem is if I change the manual entry to a DDE link that is randomly changing from 1,5,9, or whatever it no longer works. The value changes, but the copy portion does not. Almost as if Excel does not see the value change.

What is the trick to moving a ever changing DDE Linked value on change? 1,4,,6,6,7,8,98,0,0 etc.

 

[bobsan42]

No event is triggered - the copying part is probably a macro that runs when the cell is changed, but DDE change will not trigger it.

I have no means to test this now, but check these links (information is controversial):

https://social.msdn.microsoft.com/F...triggered-by-a-dde-external-link?forum=isvvba

https://www.ozgrid.com/forum/forum/help-forums/excel-general/8502-detect-dde-link-update

Also some here (maybe this will be most helpful):
https://www.mrexcel.com/forum/excel...-certain-cell-value-changing-via-dde-app.html