Assigning Properties to SHAPES

[plans]

Hello,
I am inserting a shape in my worksheet.
Is it possible to assign a size property to that shape?
I mean, if the shape is a LINE and I want to assign that line a length, say 10 Ft. I want to be able to use the value of 10 in my Excel calcs; or, if I inserted a RECTANGLE, I want to assign that rectangle a width and length and use the area value in my calcs.
The next step would be to have excel dynamically evaluate the values if I strech the shapes.
Thanks

[LJMetzger]

Hi plans,

Shapes (including lines) have the attributes of Left, Top, Height, Width in arbitrary Excel Units. Your mission if you choose to accept it, is to change the arbitrary Excel units into Engineering Units.

The following macros may help you.

Please Login or Register  to view this content.

To prevent typos from ruining days and weeks of work 'Option Explicit' is NEEDED at the top of each code module. This prevents errors caused by missspellings and FORCES every variable to be DECLARED (e.g. Dim i as Integer). http://www.cpearson.com/excel/DeclaringVariables.aspx

I hope this helps.

Lewis

[plans]

Thank you;
It is a good guideline; it helps to start!