DDE Links

A

Alec Kolundzic

In a command button, I have the following code:-

Call PutBvar("SYMBOL", Range("A8"))

This passes the value of A8 into a variable in another
program.

Is there any way I can automate this process, for instance
if the value in A8 changes, then pass the value into the
variable. I am reluctant to use the worksheet
selectionchange or calculate method because there is a lot
of variables and there is a risk of excel crashing.

Thanks
Alec
 
Top