Grouping Option Buttons

  • Thread starter Thread starter m@_
  • Start date Start date
M

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.
 
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.
 
Tom said:
*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

*
Click to expand...

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
 
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.
 
Back
Top