macro/worksheet/chart interaction
 

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

nc10001


--
nc10001
------------------------------------------------------------------------
nc10001's Profile: http://www.excelforum.com/member.php...o&userid=25750
View this thread: http://www.excelforum.com/showthread...hreadid=391616

This post is in other newsgroups. Posting the same question in multiple
newsgroups can cause redundant effort on the part of the responders.
--
Earl Kiosterud
www.smokeylake.com

"nc10001" wrote in
message ...

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

nc10001


--
nc10001
------------------------------------------------------------------------
nc10001's Profile:
http://www.excelforum.com/member.php...o&userid=25750
View this thread: http://www.excelforum.com/showthread...hreadid=391616