Consulting

Results 1 to 2 of 2

Thread: How to obtain properties of graphical "line"

  1. #1

    How to obtain properties of graphical "line"

    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.

  2. #2
    Distinguished Lord of VBAX VBAX Grand Master Bob Phillips's Avatar
    Joined
    Apr 2005
    Posts
    25,453
    Location
    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.
    ____________________________________________
    Nihil simul inventum est et perfectum

    Abusus non tollit usum

    Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
    James Thurber

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •