Point to pixel conversion in Excel VBA

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 series on a sheet chart. I want to be able to draw a horizontal line through the user selected point and then after all desired lines have been added (and perhaps moved and/or deleted), retrieve the x,y coordinates of the points where the horizontal lines intersect the series (data) line, in the data coordinate system. Are these methods/functions available only in newer versions of Excel?

Thanks,
Paul Hudgens
Denver

Comments

  • Also, as an afterthought, is TWIPSPERINCH a defined variable in older versions of Excel/VBA? If not, can it be calculated on older versions? Is it a constant?

    Thanks,
    Paul H.
Sign In or Register to comment.

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

In this Discussion