Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form vs. Control Toolbox
Can someone give a concise explanation of the difference
between the "Control Toolbox" and "Forms" toolbars in Excel? They seem to have a number of duplicate controls on them. What would be the difference in usage between the two? Thanks. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form vs. Control Toolbox
For a Worksheet:
If you want to use multiple events, and have much richer control on appearance and behavior, then use the control toolbox toolbar controls. If you want controls that are linked to cells and update on each calculate eve5/nt and are very compatible with Excel, or implement a very simple event model (click only), then use the forms toolbar. For a Userform Only control toolbox toolbar controls for a Dialogsheet Only forms controls. If you need to work with xl5/xl95, then only the forms controls. -- Regards, Tom Ogilvy "Jim Henderson" wrote in message ... Can someone give a concise explanation of the difference between the "Control Toolbox" and "Forms" toolbars in Excel? They seem to have a number of duplicate controls on them. What would be the difference in usage between the two? Thanks. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form vs. Control Toolbox
Hi,
The Control Toolbox is the newest version, that could be use on sheets and user form, and they have several events. The Forms toolbar come from the version 5, usable only on sheets, and have only the click event. They are kept for backward compatibility. -- JP http://www.solutionsvba.com "Jim Henderson" wrote in message ... Can someone give a concise explanation of the difference between the "Control Toolbox" and "Forms" toolbars in Excel? They seem to have a number of duplicate controls on them. What would be the difference in usage between the two? Thanks. |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Form vs. Control Toolbox
Thanks to both for your response.
-----Original Message----- Can someone give a concise explanation of the difference between the "Control Toolbox" and "Forms" toolbars in Excel? They seem to have a number of duplicate controls on them. What would be the difference in usage between the two? Thanks. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Control Toolbox | Excel Discussion (Misc queries) | |||
Is it possible to create a dynamic range in CONTROL TOOLBOX (form) | Excel Discussion (Misc queries) | |||
Where is the control toolbox? | New Users to Excel | |||
Where is the control toolbox? | New Users to Excel | |||
control toolbox | Excel Programming |