Excel Option Buttons

[billheath]

I am using 2010. I need to have 2 or more groups of option button on a single spread sheet. Each set needs to act independently. One set has three options. Pressing one of the radio buttons turns off the other 2. The next set may have 4 options. Again, when pressing one of these, the other three should turn off.
However, all buttons act together. Clicking any one will turn all the others off. I have tried grouping the sets to no avail. I have tried to rename the active cell for each. However, When I change one reference, they all change. Not sure what to do!
I remember doing this with earlier versions of MS Office. Any advice would be appreciated!! Thanks, Bill

 

[SkipVought]

Hi,

Put a Group Box around each group.

 

[SkipVought]

Also each Option Button group should reference a different cell.

 

[Andrzejek]

I don’t know if that’s going to help you or not, but with the option buttons on the VBA Form in Excel, you can specify GroupName of several option buttons, and different GroupName of other option buttons in the same ‘container’ and they will behave independently.
I don’t know if that’s available for the option buttons on the spreadsheet, tho.


Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[billheath]

Excel doesn't seem to give me the option of naming the groups, And, when I try to reference the cells for the groups, it changes all buttons at the same time, no matter How I have them grouped.

 

[SkipVought]

If this is a Forms control, there ought to be a Group Control that the option buttons group should be enclosed in.