enabling chart events for an embedded chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is it a problem to enable chart events for an already existing embedded
chart, or am I better off enabling events prior to actual charting of data?

Wazooli
 
Is it a problem to enable chart events for an already existing embedded
chart, or am I better off enabling events prior to actual charting of data?

Wazooli
Click to expand...
No difference. Of course, the chart has to exist before you associate
events with it.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 
This article gives you the basics:

http://support.microsoft.com/default.aspx?scid=kb;en-us;161858
XL97: How to Trap Events for an Embedded Chart

You note that you set up the class module and then assign a specific chart
to the class. So to use chart events, the chart has to exist. Thus you can
assign it to an existing chart or create a new one and assign it to that.
If you want to handle multiple charts with the class, one way is you can use
an array as shown in this approach by John Walkenbach (this is to handle
multiple commandbuttons with a single class module, but the principles are
the same).

http://www.j-walk.com/ss/excel/tips/tip44.htm
Handle Multiple UserForm Buttons With One Subroutine
 
Back
Top