Creating a simple drawing using Excel

[T5fingersWhite]

I have been creating a program that produces quantity lists for masonry walls
from the input of the dimesions of the wall. I am using Excel for the input
values. I would like to create a simplified graphical drawing of the wall
from these input values. Paint would be an ideal program but somthing
similar will do. I do not know how to change the input dimensions into a
picture which is drawn to scale. Are there any programs avalable that can do
this. The picture only needs to be simple eg. rectangles. Any info would be
greatly appreciated.

 

[John]

Hi
Don't know if that can help you, but below are vba code to create a rectangle
or square
based on dimension you put in cell C2 and C3, that you can change to your
choice.
Dimensions for the shapes are in points: 72 points = 1 inch.
It also colours the shape but you can remove that by deleting the line or change
the number ex; 41 light turquoise to something else.
----------------------
Sub Make_Rectangles()
Height_size = Range("c2").Value
Width_size = Range("c3").Value
ActiveSheet.Shapes.AddShape(msoShapeRectangle, 0, 0#, Width_size,
Height_size).Select
Selection.ShapeRange.Fill.ForeColor.SchemeColor = 41
End Sub

 

[Gilbert]

AutoCad