Recognize a chart-datapoint for use in vba

  • Thread starter Thread starter hglamy
  • Start date Start date
H

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
 
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
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
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
 
Back
Top