changing cells

[peter]

hi, i have a question regarding something i'm trying to
chart.

i have seven cells, all OLE linked to a program. thus,
these cells change constantly.

here's an example of what i'm trying to accomplish. let's
say cells A1:A3 have the links.

for ease, how do i make a chart graphing the value of cell
A2 vs. value in A3? I want the data points to chart
everytime the value in A1 changes (when A1 changes, all
other cells change as well). Thus, the graph will keep
growing, and add new data points accordingly.

sorry for the long post.

 

[Jon Peltier]

Peter -

It's tricky to keep older values from linked cells like this. You could
write a program to store the values elsewhere in the worksheet, but the
events that tell the macro when to run are not reputed to be reliable.

There's another approach using circular references, described by Stephen
Bullen: http://bmsltd.co.uk/DLCount/DLCount.asp?file=Previous.zip

- Jon