ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Difference of Control toolbox / Forms ? (https://www.excelbanter.com/excel-programming/325388-difference-control-toolbox-forms.html)

Ming[_3_]

Difference of Control toolbox / Forms ?
 
Dear Excel friends,

I am trying to program the Excel using Visual Basic .NET for Office.
Now, I want to put some control on my Excel sheet, such as Command button,
List box, etc. However, when I go to View|Toobars menu, I can see there
are two items, "Control toolbox" and "Forms" separately . But I don't know
what are the difference between them. May I know what is their difference ?
Also, may I know how to refer to the control in the sheet from the VB
code ?
Is it something like Activesheet.Listbox1.StrollDown ?
Thank you very much for your help.

Regards,
Woo Chat Ming.

--
Using Opera's revolutionary e-mail client: http://www.opera.com/m2/

OJ[_2_]

Difference of Control toolbox / Forms ?
 
Hi,
Forms controls are Excel's built in controls. Control Controls are
external ActiveX controls. Although they are a little less functional I
recommend using Excel's built in Form controls on a worksheet. From
experience they are just a little less troublesome....

Hth,
Oli



All times are GMT +1. The time now is 10:06 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com