Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
enabling chart events for an embedded chart
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
enabling chart events for an embedded chart
In article ,
says... 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 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
enabling chart events for an embedded chart
This article gives you the basics:
http://support.microsoft.com/default...b;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 -- Regards, Tom Ogilvy "Wazooli" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enabling Events | Excel Discussion (Misc queries) | |||
Embedded Chart Versus Chart - ShowDetail Issue | Charts and Charting in Excel | |||
what is the difference between embedded chart and chart-in-a-sheet | Excel Programming | |||
Enabling a Embedded Control | Excel Programming | |||
Enabling a Embedded Control | Excel Programming |