Option Buttons

[Colin Macleod]

I'd like to include two sets of option buttons on a worksheet. One set
should be linked to one cell, and the other linked to a separate cell, so
that both sets operate independently. How do I do this? If I try adding a
new option button, with a new linked cell, then all the option buttons
become linked to this cell.
Thanks

Colin Macleod

 

[Dave Peterson]

You can add optionbuttons from either the Forms toolbar or from the Control
Toolbox toolbar.

For the forms toolbar, you can put the "grouped" optionbuttons inside a GroupBox
(also on the Forms toolbar).

For the Control toolbox toolbar:
click on the "design mode" icon (also on the control toolbox toolbar)
For each "grouped" optionbutton--
rightclick on it and select properties.
Look for GroupName
give each group its own unique name
(since it defaults to the sheet name, they're all grouped to start)

 

[Peter Atherton]

Colin

Assuming that you are using Excel's Form Toolbars.

1. Draw a group box and add an option button within ththe
group box. Format the OPtion button. All options button
within the group box will be linked to this cell.

2. Draw a second group box and add a new option buton and
link this to the second cell.

Regards
Peter