Form Toolbar verses Control Toolbar

[ub]

Hi
Can any one explain the difference between Form Toolbar and Control Toolbar
and also when to use them

 

[Jim Thomlinson]

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.

 

[ub]

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

 

[Dave Peterson]

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.