Enter dimensions and have excel draw rectangle

[wagaman.m]

I want to find a way to be able to enter a length and width and have excel draw a box representative of these dimensions. Does anyone know how I can do this?

[Jakobshavn]

Here is an example:

Please Login or Register  to view this content.

The numerical values are in units of pixels.

[wagaman.m]

Thanks, I was able to run that and get it to work, along with change the size. However, I want to be able to enter a length and width in feet or or inches into a cell and then have the box appear (all I need is the outline of a box). This is my first time working with developer so any directions would be very helpful.

[Jakobshavn]

That is not easy...........I could give you code for a Message Box to popup and allow you to enter the dimensions, but they would be in points. To convert to inches, we would need more details on your monitor, zoom level, etc.

[wagaman.m]

Ok, I think I am in over my head here and should try another route. Thanks though

[Jakobshavn]

Update this post if you want to continue.