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

Wildcard in VLOOKUP
Use =VLOOKUP("Apple*" to find apple, Apple, or applesauce

bobsan42

Well-known Member
Joined
Jul 14, 2010
Messages
1,343
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,109,453
Messages
5,528,875
Members
409,843
Latest member
akostaki
Top