How do I group option buttons?

[machinegod]

I'm trying to separate two sets of option buttons. When changing the values in one column from the "Table" sheet, it affects both sets of buttons on "Sheet1". How do I prevent this from happening?

I only want the associated column from the "Table" sheet to affect its button set on "Sheet1".

Here is the code that I'm working with...

Please Login or Register  to view this content.

[rorya]

Put a groupbox round each set.

Also, FYI, this code:

Please Login or Register  to view this content.

tests if the value of the changed cell is the same as the value in A2; it does not test if it was A2 that was changed.

[machinegod]

I did put a group box around them and the problem persists.

[rorya]

You must have done something wrong.

[machinegod]

You must have done something wrong.

Thank you! I thought I had grouped them.