Custom Tooltip for MouseMove event

[mangesh_yadav]

Hi Andy,

I have seen the addin. Somehow it doesn't work on my machine (maybe it
something to do with my settings for the graph), but the main reason i
that the code is not available and I don't want to install addins.
would like to add my text to the tooltip and for this I require th
code and not the addin.

Thanks for the response in any case.

- Manges

 

[Jon Peltier]

Mangesh -

I have some rudimentary code that detects which point was clicked on:

http://peltiertech.com/Excel/Zips/GetXYonaChartSheet.zip
http://peltiertech.com/Excel/Zips/GetXYonAnyChart.zip

You can modify this for mouse move events, pop up some kind of textbox rather than
the message box in my example. You cannot access the chart tips; you disable these
and pop up a custom textbox which may or may not be formatted to resemble a chart tip.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______