Drawing Shapes In A Userform (Simple Circles and Rectangles)

JerBearG

New Member
Joined
Oct 4, 2014
Messages
12
Hello world!

This is purely for visual "scale confirmation" and aesthetics, but I know it is possible and I'd like to implement this into my userform.

I've got users who will be selecting between different shapes (during quoting) that we will be cutting in our steel shop. If they select our stock shape "Ring" and enter the outside and inside diameters, I want a scaled version of that exact ring to be drawn in my userform in a picture "framed" area next to the input section. The same goes for if they select Rectangle, and that's about it... I just want my users to be able to see a fat rectangle or a skinny one depending on the dimensions of the rectangle, same goes for the rings... (small or large difference between inside and outside diameter). For this application, any "Disc" shape would always look the exact same since it would be scaled to fit the "viewing area"

I've seen this guide, but I'm not sure how I would implement this into my existing userform: Draw on userform


It would help a lot if I can simply see how someone has successfully drawn a rectangle and a circle of variable dimensions into a userform!

Thanks in advance.

Note: Input only comes from two textboxes (two variables) "Width or OutsideDiameter" and "Length or InsideDiameter". I have error checkers to make sure that the width is always shorter than the length for rectangles, and the opposite for discs/rings (OD > ID). (this is odd from a programming standpoint, but it's basically an industry standard)
 
Note: I use excel 2007. Thanks everyone for taking the time to look and think about this interesting problem.

Ps. Bump!
 
Upvote 0

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top