Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pause while user clicks on chart series
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 "Jim Thomlinson" wrote: 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 Was this post helpful to you? Why should I rate a post? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pause while user clicks on chart series
You can use chart events to launch procedures:
http://www.computorcompanion.com/LPMArticle.asp?ID=221 - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "JayWes" wrote in message ... 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 "Jim Thomlinson" wrote: 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 Was this post helpful to you? Why should I rate a post? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pause while user clicks on chart series
http://support.microsoft.com/kb/213738/en-us
XL2000: How to Trap Events for an Embedded Chart -- Regards, Tom Ogilvy "JayWes" wrote: 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 "Jim Thomlinson" wrote: 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 Was this post helpful to you? Why should I rate a post? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Selectable Series and Number of Series for Line Chart | Charts and Charting in Excel | |||
Pause While User Clicks on Chart Series | Excel Programming | |||
How to have errr msg pop up when user clicks on locked cell | Excel Discussion (Misc queries) | |||
Counter for user clicks | Excel Programming | |||
How can I execute a macro right after the user clicks the validation drop down? | Excel Programming |