Point to pixel conversion

[phudgens]

I'm using VBA 6.5 in Excel V11.8307 and am wondering if there are any functions/methods that can be invoked to do a point to pixel conversion (or vice versa) when a point is selected on a sheet chart. I want to be able to draw a horizontal line through a user selected point and then after all desired lines have been added (and perhaps moved and/or deleted), retrieve the x,y coordinates of those points in the data coordinate system. Are these methods/functions available only in newer versions of Excel?

Thanks,
Paul Hudgens
Denver

[phudgens]

I should add that the point selected would only be on a plotted series, and the ultimate list of points that I'm after is where the horizontal lines intersect the plot.

Thanks,
Paul H.