Can't find Line/Shape Controls in VBA

[gobrikings]

I'm a VBA newbie, so this is probably a dumb question. I'm trying to add some lines and shapes to a userform, and the controls aren't shown in my toolbox or in the Additional Controls list. I'm using Excel 2003 from Office Standard addition. Are the controls just not there or am I missing something obvious? Have searched high and low on MSDN website with no luck. HELP!!!!!

 

[Tazguy37]

I hit reply before I noticed you were talking about a userform. You can add a frame to outline things on a userform.

There is no userform line control. For vertical and horizontal lines you can use a label control with a width/height of 1.
For lines other than vertical or horizontal you can use an image control.
Create the required line on a worksheet using the drawing objects. Copy the line to the clipboard using CTRL+C. Then select the Picture property of the Image control and paste the image using CTRL+V

Hope that helps!

 

[gobrikings]

Thanks much for ending my frustration--that did the trick!

 

[Tazguy37]

Glad you got it working! Send your thanks to Andy Pope at http://www.ozgrid.com/forum/index.php?. I got that from a post he made.