mouseover mschart solved

[Z]

Turns out that twipstochartpart actually does do what I thought and it is
not broken. I kept getting errors trying to use it as it was shown in the
docs. The docs were the problem!

From the docs:
Identifies a chart part by using the x and y set of coordinates on to
identify that part.

Syntax

object.TwipsToChartPart (xVal, yVal, part, index1, index2, index3, index4)

The TwipsToChartPart method syntax has these parts:

<snip>
if you use it as shown, you get an error saying it wants to be equated to
something, e.g.

ObJectTHingy=MSChart.TwipsToChartPart (xVal, yVal, part, index1, index2,
index3, index4)

Which gives a type mismatch.

Fact is you have to use it without brackets and not assigning to anything.
You supply X and Y, it fills in the rest, e.g.

MSChart.TwipsToChartPart xVal, yVal, part, index1, index2, index3, index4