Can't find Line/Shape Controls in VBA

gobrikings

New Member
Joined
Jan 22, 2005
Messages
2
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!!!!!
 

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

Tazguy37

MrExcel MVP
Joined
May 28, 2004
Messages
4,237
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!
 

Forum statistics

Threads
1,147,674
Messages
5,742,541
Members
423,736
Latest member
dracula cyrus

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
Top