Creating a simple drawing using Excel

  • Thread starter Thread starter T5fingersWhite
  • Start date Start date
T

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.
 
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
 
Back
Top