![]() |
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/ |
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