Excel 2010 adding shapes to a form manually during design time

[DHeshMan]

Ok,
This may seem like a simple question, but I'm obviously missing something. I have seen plenty of posts on how to add shapes to a form dynamically using code, but I just want to draw some items manually on a custom form in the VB environment of Excel 2010.

In Visual Studio 2010, the VB environment there contains in its Toolbox a "Power Packs" section that contains a LineObject, OvalObject, and RectangleObject, that I can click and drag onto a form, but I can't seem to find these in the Excel VB environment. I understand that the Excel VB environment is not the same as my Visual Studio, because the syntax between the 2 is slightly different. (I think VS is using VB.Net while the Excel code is not).

So if anyone can please help me from feeling like an idiot and tell me how to draw graphical items other than just what is on the basic ToolBox on a form in Excel, it would be greatly appreciated. As a follow up to this, how about polygons, arcs or pie shapes? Not everything is just a line, an oval, or a rectangle.

Thanks.

[LJMetzger]

Hi DHeshMan and welcome to ExcelForum,

Actually, it is not a simple question at all.

I'm not sure if it's possible to do what you want manually.

See the following, thanks to Andy Pope who has written some super amazing code over the years: http://www.andypope.info/vba/userformdraw.htm

Lewis