Recognize a chart-datapoint for use in vba

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....html#PointInfo)

hglamy wrote:

> 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

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


"Andy Pope" <andy@andypope.info> schrieb im Newsbeitrag
news:eCEfxbEsDHA.2392@TK2MSFTNGP10.phx.gbl...
> Hi H.
>
> Maybe Jon's example will give a starting point.
> (http://www.geocities.com/jonpeltier....html#PointInfo)
>
> hglamy wrote:
>
> > 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
>

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

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Andy Pope wrote:

> Hi H.
>
> Maybe Jon's example will give a starting point.
> (http://www.geocities.com/jonpeltier....html#PointInfo)
>
> hglamy wrote:
>
>> 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
>>
>>
>>
>

Thank you, Jon !

Kind regards,

H.G. Lamy

"Jon Peltier" <jonpeltierNOSPAM@yahoo.com> schrieb im Newsbeitrag
news:#j6zHxFsDHA.2408@tk2msftngp13.phx.gbl...
> Another suggestion is Tushar Mehta's Hover Chart Label add-in, available
> from http://tushar-mehta.com.
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> http://www.geocities.com/jonpeltier/Excel/index.html
> _______
>
> Andy Pope wrote:
>
> > Hi H.
> >
> > Maybe Jon's example will give a starting point.
> >
(http://www.geocities.com/jonpeltier....html#PointInfo)
> >
> > hglamy wrote:
> >
> >> 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
> >>
> >>
> >>
> >
>