macro/workseet/graph interaction

[nc10001]

I am running a macro which simulates an engineering application. The macro
essentially time steps, sending the data at each time step to a worksheet,
and a chart is set up to display the data in graphical form.

Problem - although the worksheet is updated at each time step, the chart
only updates when the macro has finished executing - and I want to see the
data being graphed as the simulation proceeds - is there anyway of getting
the macro to pause while the chart is updated - some kind of handshake
between EXCEL and the macro? (At the moment the only way I can do this is to
put a STOP in the code loop.)

Thanks in advance

 

[seisman]

Make sure you have Application.Screenupdating = true and try using the
DoEvents function. Or you could use OnTime to run the elements of your
simulation at the time intervals you require.
Seisman