Radio Buttons not Holding Values

[zalik22]

Hi,

I have two worksheets and each worksheet has 2 sets of Yes/No Radio buttons. If I select "Yes" and "No" on one spreadsheet, when I click on the 2nd spreadsheet, the values are reset. If I click new values on the 2nd spreadsheet, whatever I selected in the first spreadsheet is reset. Any idea what is causing this? I was given the file by someone else and I am not too familiar with radio buttons, so any help is much appreciated. I wen into developer and noticed the buttons on both sheets are named buttons 7-10. Thanks!

 

[mole999]

maybe they are being reset with a worksheet_change event

 

[zalik22]

Is there a way to see if there is code that is changing these sheets?

 

[mole999]

Right click on the tab and view code or Alt-F11 to open the macro window, then you need to see what is there

 

[zalik22]

One tab has below and the other has the same with OptionButtons 7-10:

Private Sub OptionButton11_Click()
End Sub
Private Sub OptionButton12_Click()
End Sub
Private Sub OptionButton13_Click()
End Sub
Private Sub OptionButton14_Click()
End Sub

 

[mole999]

like that they do nothing, does the workbook have any code

 

[zalik22]

There is code on another worksheet, but these two are not ever referenced.

 

[Eric W]

Are they form controls? If so, are the buttons of each set surrounded by a group box?

Or are they Active-X controls? If so, what is the GroupName of each control? Click Design Mode from the Developer tab, right click the button, and select Properties.

 

[zalik22]

Thanks, so much! The user must have copied and pasted the buttons so they were part of the same group name. I changed it and it worked!

 

[Eric W]

Glad we could help.