Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Creating a simple drawing using Excel

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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 694
Default Creating a simple drawing using Excel

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
----------------------
HTH
John
"T5fingersWhite" wrote in message
...
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.


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 74
Default Creating a simple drawing using Excel

AutoCad


"T5fingersWhite" wrote:

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.

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Creating a simple chart Keith Charts and Charting in Excel 1 September 1st 08 05:43 PM
screen goes black when creating or dragging drawing objects ... Tori Dunbar Excel Discussion (Misc queries) 1 February 4th 08 04:19 PM
Creating what should be a simple macro Dwight Excel Discussion (Misc queries) 6 April 13th 07 06:38 PM
Excel 2003 - Drawing a Simple Line - Dissapears SCPU173 Excel Discussion (Misc queries) 0 March 12th 06 11:48 PM
PLEASE HELP!? Creating a simple database with excel, minor setback Pre-construction Manager & Excel !? Excel Worksheet Functions 1 November 30th 04 08:59 PM


All times are GMT +1. The time now is 07:27 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"