X-Y axis

F

famdamly

Is there a way I could get the x and y axis coordinates to display in
cell as I drag the shape around with a mouse?

Example

ActiveSheet.Shapes.AddLine(14.25, 7.5, 143.25, 8.25).Select
With ActiveSheet.Shapes.BuildFreeform(msoEditingAuto, 10.5
378.75)
.AddNodes msoSegmentLine, msoEditingAuto, 10.5, 297#
.AddNodes msoSegmentLine, msoEditingAuto, 109.5, 297#
.AddNodes msoSegmentLine, msoEditingAuto, 109.5, 381#
.AddNodes msoSegmentLine, msoEditingAuto, 10.5, 378.75
.ConvertToShape.Select

I want to be able to cross compare other shapes relative to the ne
position of this shape after it has been drug around by a mouse.lol

I know nothing, about how to do that
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

OpenXML SDK Preset AutoShapes, BuildFreeForm and Fill Problems 0
Drawing a Curve programmatically 1
Excel 2007: X-axis labeling 1
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) 1
Excel: secondary Y axes with log-scale X axis 1
Charts-text for x & y axis and titles 5
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
respect proportions of x and y axis 4

Top