De: David Hager <104074.3422@compuserve.com>
Objet: Re: MOUSE EVENTS IN EXCEL
Date : jeudi 9 septembre 1999 12:28

Now I remember<g>. You have to use class modules to create the events for
charts in chartobjects. Something like:

In a class module named EventClassModule

Public withEvents myChartClass As Chart

Private Sub myChartClass_MouseMove(ByVal Button As long, ByVal Shift As
long, ByVal X As long, ByVal Y As long)
    MsgBox "Test"
End Sub

and in a standard module>

Dim myClassModule As New EventClassModule

Sub InitializeChart()
    set myClassModule.myChartClass = _
        Worksheets(1).ChartObjects(1).Chart
End Sub

David Hager <104074.3422@compuserve.com> wrote in message ...
>I am wrong. I remember a project where I tried to simulate chartobject
>events, and I mistakenly pulled that thought out of my head as real
>chartobject events. Sorry.
>
>David
>
>Phil Adamson wrote in message ...
>>I need mouse events to manipulate xl charts. I can' use userforms as they
>>obscure the xl charts.   does anyone know where to find appropriate code?
>>
>>Phil
>>
>>
>
>