ERLANDSEN DATA CONSULTING Excel & VBA Tips   Informasjon på norsk / Information in Norwegian

These pages are no longer updated and are only available for archive purposes.

Click here to visit the pages with updated information.

Chart object events

If you want to write event procedures for an embedded chart, you will have to create a class module to do this:

Start the Visual Basic editor.
Select the desired project in the Project-window.
Insert a new class module by selecting the menu Insert | Class Module.
Activate the new class module and rename it, e.g. ChartEventClass
Copy and paste this example macro to the new class module:

Public WithEvents ChartObject As Chart

Private Sub ChartObject_Select(ByVal ElementID As Long, _
    ByVal Arg1 As Long, ByVal Arg2 As Long)
End Sub

' add more macros for the other available chart events if necessary...

After you have finished editing the event macros for the Chart object, you have to add some code to the module ThisWorkbook to activate the new event macros:

Dim ChartObjectClass As New ChartEventClass

Private Sub Workbook_Open()
    Set ChartObjectClass.ChartObject = Worksheets(1).ChartObjects(1).Chart
End Sub

After you run the Workbook_Open procedure, the events attached to the first Chart object  in the first worksheet are activated.



Document last updated 1999-08-21 12:47:53      Printerfriendly version


Erlandsen Data Consulting   
Excel & VBA Tips   Copyright ©1999-2017    Ole P. Erlandsen   All rights reserved
E-mail Contact Address