Recognize a chart-datapoint for use in vba

[hglamy]

Hello there,

I would like be able to start a VBA-Procedure, when
the mouse pointer hovers over a certain data point in
a chart (XL 2003).

Obviously, XL knows when the cursor "touches" a data
point, since it displays a tool tip with its values.

Can I, and if so how, make use of that XL-side trapping
of spots under the mouse to harness it for a macro ?

Thank you in advance.

Kind regards,

H.G. Lamy

 

[Andy Pope]

Hi H.

Maybe Jon's example will give a starting point.
(http://www.geocities.com/jonpeltier/Excel/Charts/chartvba.html#PointInfo)

Hello there,

I would like be able to start a VBA-Procedure, when
the mouse pointer hovers over a certain data point in
a chart (XL 2003).

Obviously, XL knows when the cursor "touches" a data
point, since it displays a tool tip with its values.

Can I, and if so how, make use of that XL-side trapping
of spots under the mouse to harness it for a macro ?

Thank you in advance.

Kind regards,

H.G. Lamy

--

Cheers
Andy

http://www.andypope.info

 

[hglamy]

Thank you, Andy,

I thought I knew Jon's site,
but I obviously I have never
got to the "PointInfo"-samples.

Kind regards,

H.G. Lamy

 

[Jon Peltier]

Another suggestion is Tushar Mehta's Hover Chart Label add-in, available
from http://tushar-mehta.com.

- Jon

 

[hglamy]

Thank you, Jon !

Kind regards,

H.G. Lamy

Another suggestion is Tushar Mehta's Hover Chart Label add-in, available
from http://tushar-mehta.com.

- Jon