Hi all,
Problem I.
I am new to vb macro coding stuff. I was trying to write code to do some calculations using worksheet_change, but later i came to know that a dde link doesn't trigger the calculations. If someone can help me in this problem I will really appreciate.
Problem II.
As an alternate route to above problem i tried to use a infinite loop that keep on executing itself but it hangs up my excel. i cant do anything while its working rather it doesn't even updates dde link values.
Note DDE link is in "$A$1"
Problem I.
I am new to vb macro coding stuff. I was trying to write code to do some calculations using worksheet_change, but later i came to know that a dde link doesn't trigger the calculations. If someone can help me in this problem I will really appreciate.
Problem II.
As an alternate route to above problem i tried to use a infinite loop that keep on executing itself but it hangs up my excel. i cant do anything while its working rather it doesn't even updates dde link values.
Note DDE link is in "$A$1"
