PDA

View Full Version : How to obtain properties of graphical "line"



TomSmith
05-30-2008, 02:09 PM
Hello,

I sometimes use Excel's drawing facilities as a "mini-CAD" software to manually create (or programmatically generate) engineering-type CAD sketches.

Using VBA, how can I obtain the coordinates of an existing line?

Can this be done if the line is part of a "group"?

Thank you.

Bob Phillips
05-30-2008, 02:41 PM
The Shapes object has a number of properties, Left, Top, Width, Height, etc. that you can use.

Groupde shapes have a GroupItems collection that you can examine.