Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Form Toolbar verses Control Toolbar
Hi
Can any one explain the difference between Form Toolbar and Control Toolbar and also when to use them |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Form Toolbar verses Control Toolbar
The controls from the forms toolbar are part of XL. You attach macros from
modules directly to the control. This can be handy as the controls are not embeded in the sheet and they do not place any code in the sheet. Controls from the control toolbox are embeded objects. If you are fimiliar with VB6 these controls are almost identical to the controls you would embed in a userform. Since these controls are embedded they place their code directly in the sheet. The up side is that they have a rich set of properties and methods. Much more than controls from the forms toolbar. 99% of the time I use controls from the controls toolbox as I like the rich set of properties and methods and the easy of referencing the controls in code. That is not to say the forms controls don't have a place though. -- HTH... Jim Thomlinson "ub" wrote: Hi Can any one explain the difference between Form Toolbar and Control Toolbar and also when to use them |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Form Toolbar verses Control Toolbar
Can the control toolbar be used with option button, when I want to group the
options button and capture the value in another cell. Because with form toolbar, I am able to to do this by selecting property- Control under Format Object Please advise "Jim Thomlinson" wrote: The controls from the forms toolbar are part of XL. You attach macros from modules directly to the control. This can be handy as the controls are not embeded in the sheet and they do not place any code in the sheet. Controls from the control toolbox are embeded objects. If you are fimiliar with VB6 these controls are almost identical to the controls you would embed in a userform. Since these controls are embedded they place their code directly in the sheet. The up side is that they have a rich set of properties and methods. Much more than controls from the forms toolbar. 99% of the time I use controls from the controls toolbox as I like the rich set of properties and methods and the easy of referencing the controls in code. That is not to say the forms controls don't have a place though. -- HTH... Jim Thomlinson "ub" wrote: Hi Can any one explain the difference between Form Toolbar and Control Toolbar and also when to use them |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Form Toolbar verses Control Toolbar
If you use optionbuttons from the Forms toolbar, put a groupbox (also on that
same toolbar) around the optionbuttons. And then rightclick on an optionbutton on that group, choose Format Control|control tab. Then assign the linked cell. If you use optionbuttons from the control toolbox toolbar, rightclick on each of the members of the group, choose properties, and give that group a unique groupname. You can assign the Linkedcell on that properties window. ub wrote: Can the control toolbar be used with option button, when I want to group the options button and capture the value in another cell. Because with form toolbar, I am able to to do this by selecting property- Control under Format Object Please advise "Jim Thomlinson" wrote: The controls from the forms toolbar are part of XL. You attach macros from modules directly to the control. This can be handy as the controls are not embeded in the sheet and they do not place any code in the sheet. Controls from the control toolbox are embeded objects. If you are fimiliar with VB6 these controls are almost identical to the controls you would embed in a userform. Since these controls are embedded they place their code directly in the sheet. The up side is that they have a rich set of properties and methods. Much more than controls from the forms toolbar. 99% of the time I use controls from the controls toolbox as I like the rich set of properties and methods and the easy of referencing the controls in code. That is not to say the forms controls don't have a place though. -- HTH... Jim Thomlinson "ub" wrote: Hi Can any one explain the difference between Form Toolbar and Control Toolbar and also when to use them -- Dave Peterson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Control Toolbar Checkboxes | Excel Discussion (Misc queries) | |||
delete control toolbar check box | Excel Discussion (Misc queries) | |||
Forms Toolbar - Scroll bar control | Excel Discussion (Misc queries) | |||
Using the Control Toolbar | Excel Worksheet Functions | |||
Using Control Toolbar | Excel Discussion (Misc queries) |