DDE Links

  • Thread starter Thread starter Alec Kolundzic
  • Start date Start date
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Involved VLookup Function 6
calculating between 2 given dates 6
URGENT: Please Advise. SumProduct and Operand Question 8
VBA equivalent for worksheet 'match'? 2
= cell in another worksheet 3
help copying formulas 1
reference cells when looping 5
question about syntax in a simple macro... 3

Back
Top