Grouping Option Buttons

[m@_]

I am trying to set up two lists with option buttons in the same
spreadsheet. The first list is working great, but when I started
building the second list, it has become part of the first list. (i.e.
If I click on the first list of five buttons, they have an assigned
value of 1-5. When I click on the second list, it goes to 6-10.) I
can't get them to function independently.

Please help.

P.S. I'm using the "forms" option button.

 

[Tom Ogilvy]

You have to put a groupbox around each group to get independent behavior.
You will need to go to at least on option button in each group and assign it
to the appropriate cell.

 

[mrpayroll]

*You have to put a groupbox around each group to get independent
behavior.
You will need to go to at least on option button in each group and
assign it to the appropriate cell.

--
Regards,
Tom Ogilvy

*

Thank you, this is a problem I'm having also. But how do you assign one
option button in each group, to an appropriate cell?

Thank you for your time, Chris

 

[Dave Peterson]

These are optionbuttons from the Forms toolbar.

Just right click on one of the buttons within the groupbox and select Format
Control. Then Control Tab, then give it a nice cell link.

Then try it with another button within the same groupbox. You'll see it's
already got a cell link.