Pause while user clicks on chart series

[JayWes]

The OnClick event only applies to making a selection on a userform "I
believe." I need the code to stop and allow me to select a data point from a
chart series such that the x and y values are assigned to variables which are
then used in for calculations throughout the remainder of the code... It's
Excel VBA doesn't allow for this in some fashion...

If I'm wrong about my previous statement regarding the OnClick event, please
elaborate.

Thanks,
Jason

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.

Was this post helpful to you?

Why should I rate a post?

 

[Jon Peltier]

You can use chart events to launch procedures:

http://www.computorcompanion.com/LPMArticle.asp?ID=221

- Jon

 

[Tom Ogilvy]

http://support.microsoft.com/kb/213738/en-us
XL2000: How to Trap Events for an Embedded Chart