Difference of Control toolbox / Forms ?

  • Thread starter Thread starter Ming
  • Start date Start date
M

Ming

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.
 
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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Back
Top