View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Pause While User Clicks on Chart Series

Once your code brings up the chart the code should end execution. You can
attach a on click event to your chart to initialize the next bit of code. In
short macro's really dont pause to wait for the user to do something. You
need to execute your code based on events generated by the user.
--
HTH...

Jim Thomlinson


"JayWes" wrote:

I have a code that exectutes, and when it comes to a certain point a chart
pops up. I want the code to pause while the user clicks on the curve. Once
this is done, the code will resume execution... In short, I can't seem to
figure out how to make the code stop and wait for a chart mouseup event
before continuing to execute... Can someone grace me with their knowledge...

Thanks for your help,
Jason