Step 2: Create the Chart Class Object in Module. We need to create the object of this class in a sub in any normal module or the object module. But the events won't work yet because it's just a class. You can create as many events you want from the available events for chart type here. I will try to show the user that the chart event is activated in a msg box. To demonstrate the use, I choose the CEvents_Activate Event. Select whichever you require and define what you want to do when that event triggers. All the available event handling procedures will be available to you in the top-right drop-down menu. From the top-left drop-down, select the CEvent object.
Set CEvents = ActiveSheet.ChartObjects(1).Chart Afterward, on the top-right drop-down, select initialize. Initialize this event in class_initialize() subroutine.įrom the drop-down on the left, select class.Define an event variable of Chart type with keyword WithEvents.Step 1: Create Chart Event Class and Define Events Second is creating an object of that event class.
First is creating chart event class and defining events. So, there are two steps to activate an embedded chart event. So without further delay, let's get started. It is much like creating application events. But I assure you that events with embedded charts are not that difficult to activate. But when it comes to using events on embedded charts, It is not that simple. Using Chart sheet events( worksheet especially for charts) is fairly simple.
0 kommentar(er)
