DDE Link and VBA question (simple I think)?

ohgeesh

New Member
Joined
Jul 2, 2015
Messages
2
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.
 

Some videos you may like

Excel Facts

What do {} around a formula in the formula bar mean?
{Formula} means the formula was entered using Ctrl+Shift+Enter signifying an old-style array formula.

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,344
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
 

Watch MrExcel Video

Forum statistics

Threads
1,113,871
Messages
5,544,787
Members
410,635
Latest member
phoenix7771
Top