control toolbox and userform toolbars in XL 03

  • Thread starter Thread starter Dave F
  • Start date Start date
D

Dave F

What is the difference between these two toolbars?

Is using one preferable to using the other?

Thanks.

Dave
 
The forms toolbar is simplest, and is probably best integrated into Excel.

The control toolbox is harder to work with, but offers more flexibility
(such as background colour of controls).

Another disadvantage of the Forms controls, no textbox. Either use a drawing
bar textbox, or a controls toolbox.

Use the one you are comfortable with. Personally, I don't like controls on a
worksheet, I prefer trapping events, or adding toolbar buttons.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
Hi,

You can use Control Toxbox icon and Form Toolbox icon in your worksheet. but
Toolbox in the UserForm is specific only to creation of interface for
Application development with the Appplication Development Environment.

Control Toolbox Action:

1. You include the controls in the Worksheet.
2. Add more controls to the tool box, by clicking the More Controls icon. By
default, 15 Controls are displayed.
3. You can associate or write a Code to each control; Set Properties to each
control. You cannot assign Macro to the control.
4. Toggle between Design Mode and Run Mode.

Forms Toolbox Action:

1. You include the controls in the Worksheet.
2. There are 16 Controls in the tool box,
3. You can assign an existing Macro, or click the New button in the Assign
Macro dialog box., Click the Record button in the Assign Macro dialog box to
start a new macro recording – Stop Recoding toolbox appears.

UserForm Tool box

This Toolbox can be used create a userinterface for a standalone application
developed using Visual Basic Application (VBA) environment.

1. Include the controls only in the User form for creating Graphical User
Interface for an application developed using VBA.
2. TabStrip, Multipage, Frames and other control available only for UserForm.

Challa Prabhu
 
Back
Top