option buttons

Topic

New Reply

Excel 2007 – previously, I had one group of 3 option buttons – all linked to the same cell. Now I added another group of 3 option buttons linked to another cell. Problem is, when I select any button in either group, it unselects all other buttons in both groups. When I change the cell link for any of the option buttons, it changes the cell link for all of them.

I would like the groups to be independent as they relate to different options.

How can I do this?

Reply | Quote

Replies

Have they been created from the Form Controls section of Insert in the Developer tab of the ribbon?

If so, you have to place the option buttons that belong together within a group box from the Form Controls section. Option buttons within a group box behave as a group, independently of other option buttons.

Reply | Quote

okay, that makes sense. I created group boxes and put them around the option buttons but it does not seem to have any effect. I also tried deleting the existing option buttons and creating new ones… no difference. I don’t think I am getting the option buttons inside the group control… any ideas?

Have they been created from the Form Controls section of Insert in the Developer tab of the ribbon?

If so, you have to place the option buttons that belong together within a group box from the Form Controls section. Option buttons within a group box behave as a group, independently of other option buttons.

Reply | Quote

Are you sure the option buttons are from the Form Controls section? If so, it should work, provided that the option buttons are completely enclosed within the group box. Take care – the outline of an option button may be larger than the button and its caption!

Reply | Quote

that was the problem… option button border outside group control border. Thank you very much.

Are you sure the option buttons are from the Form Controls section? If so, it should work, provided that the option buttons are completely enclosed within the group box. Take care – the outline of an option button may be larger than the button and its caption!

Reply | Quote

If you have option buttons from the ActiveX controls section, you need to set the GroupName property.

Reply | Quote