Grouping Optionbuttons on the Spreadsheet (Not on a Form)

**dwinmac** · 10-06-2008, 06:06 PM

I have two groups of option buttons. One group has 15 option buttons the other has 2 option buttons.

When I click on one group it deselects the option button in the other group causing no buttons to be selected in the second group.

In other word only one of the 17 buttons is shown selected at a time.

By "selected" I mean the filled in circle is shown within the larger circle.

The two groups of buttons are linked to different cells in the spreadsheet.

How do I keep the two groups from interaction with each other?

**shg** · 10-06-2008, 06:09 PM

Put each group in a separate frame.

**dwinmac** · 10-06-2008, 11:37 PM

I put the option buttons in a group box and grouped the two option buttons and the groupbox by selecting all three and right clicking to "Grouping" -> "Group". I put the other 15 option buttons in a second Group Box just as I did the two described above.

This does allow both groups to have one button selected now.

However, now my code in the sheet activate event doesn't work. Instead of causing OptionButton 16 to look selected it causes both optionbuttons in the group to appear deselected. Using the "Selection and Visibility" pane the two option Buttons are 16 and 41, the Group Box is 33 and the Group is 49.

Please Login or Register  to view this content.

I did verify that the Option Buttons are still linked to Y3.
Do I have to include the Group in the Range statement somehow?

I couldn't get the Active X frame to work at all. I inserted the frame and selected the edit mode from the right click (Frame_Object -> Edit). Then I put the option buttons in the frame. I selected the properties but I could see no way to link them to the macro they each have to run.

**dwinmac** · 10-13-2008, 06:24 PM

Basically it is solved. At least I managed to get it working the way I wanted it to.

I think the trick is not to try to copy the controls from one sheet to another but rather create them all from scratch on each sheet. Perhaps I should add "unless you really know what you are doing".

I'm not really sure that I used the group boxes and the grouping correctly. In fact on one sheet it worked properly without putting a group box around one group of optionbuttons but instead just grouped the optionbuttons.

It was a little frustrating but I'm learning.