LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
nc10001
 
Posts: n/a
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
... interaction with Word ... Dr. Darrell Excel Discussion (Misc queries) 2 July 21st 05 10:42 PM


All times are GMT +1. The time now is 04:29 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"