Hello world!
I have a unique "problem" that I'm looking to solve and I'm wondering if anyone is able/willing to take on this challenge with me.
This is purely for visual "scale confirmation" and aesthetics, but I'm pretty sure it is possible and I'd like to implement this into my userform. Even a nudge in the right direction would be great. I've seen this guide, but I'm not sure how I would implement this into my existing userform: (andy pope) http://www.andypope.info/vba/userformdraw.htm
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"
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)
Also, I use excel 2007.
Last thing, I posted this question 1 month ago here. (with no solutions or responses).
http://www.mrexcel.com/forum/excel-questions/863793-drawing-shapes-userform-simple-circles-rectangles.html
Thanks for looking,
Jeremy
I have a unique "problem" that I'm looking to solve and I'm wondering if anyone is able/willing to take on this challenge with me.
This is purely for visual "scale confirmation" and aesthetics, but I'm pretty sure it is possible and I'd like to implement this into my userform. Even a nudge in the right direction would be great. I've seen this guide, but I'm not sure how I would implement this into my existing userform: (andy pope) http://www.andypope.info/vba/userformdraw.htm
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"
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)
Also, I use excel 2007.
Last thing, I posted this question 1 month ago here. (with no solutions or responses).
http://www.mrexcel.com/forum/excel-questions/863793-drawing-shapes-userform-simple-circles-rectangles.html
Thanks for looking,
Jeremy