Draw a box in a userform using cell values

[San75]

Hi. I am trying to create a userform that will calculate the amount of material used on a floor area by simply entering values into boxes/cells. I would like the userform to generate an image/create lines to represent the floor. How should I go about this? Thanks.

[6StringJazzer]

simply entering values into boxes/cells

You need to be a lot more concrete than this. Show what boxes/cells you mean and how you would enter the data, and include an example of what you want the resulting drawing to look like.

Is the floor always a rectangle? If the floor is an irregular shape then I think you have little hope of doing this in Excel. You should use a drawing tool like Visio or Sketchup.

[Richard Buttrey]

We need more information.

Is this a perfectly square floor, or are there recesses or projections? i.e. more than four lengths at right angles to each other

Upload a workbook in which you have manually added shapes that represent all the sorts of rooms.
If it's more than a simple rectangle/square then the image will need building up from several shapes.

[torachan]

made me laff'

You need to be a lot more concrete than this.

[San75]

Thank you for all your replies. The floor will be a rectangle. I just need to enter the length and width into a textbox and generate a drawing on the screen, a bit like how a rectangle is created in a CAD application. Would Shapes.AddShape be my best route? Once I have achieved this then I can work on some VBA code to calculate certain materials.

[6StringJazzer]

A rectangle would be pretty straightforward. What scale do you want to use? If you already have an Excel file you are working with it would speed things up to attach it.

[Richard Buttrey]

Does the attached give you a starter.

You may wish to change the position of the shape (the first two variables in the .AddShape macro