Form Control --> Option Button avoid all newly created option buttons to be linked to each other.

[FuNeS13]

I recently had to add rows to a file that has two option button per row for a pass fail boolean... the original option button work great for each row, but if I copy the option buttons to the rows below or if I add them separately they all link to the each other even on different rows, if I try to group them together and/or link them to a specific cell in the row they still all change... Is there away to work around this?

 

[My Aswer Is This]

I believe it is never a good ideal to have buttons on numerous rows to perform a Task for the reason you have mentioned here.

I suggest using a sheet double click event script.

If you double click on any cell in column "A" a specific event happens
If you double click on any cell in column "B" a specific event happens

Only two small scripts are needed no matter how many rows.

 

[My Aswer Is This]

Here in this example if you double click on any cell in column A
The value "Pass" will be entered in column C
If you double click on any cell in column B
The value "Fail" will be entered in column C

This is an auto sheet event script
Your Workbook must be Macro enabled
To install this code:
Right-click on the sheet tab
Select View Code from the pop-up context menu
Paste the code in the VBA edit window

Private Sub Worksheet_BeforeDoubleClick(ByVal Target As Range, Cancel As Boolean)
'Modified  12/14/2021  3:33:05 AM  EST
Cancel = True

    Select Case Target.Column
        Case 1
            Target(, 3).Value = "Pass"

        Case 2
            Target(, 2).Value = "Fail"

    End Select
End Sub

 

[FuNeS13]

Thank you very much for your help, it totally makes sense... I will try it out