Option Buttons use for Yes/No questions on a worksheet not able to select more than one

[Cdavies]

I have a worksheet with questions and I have to create options of yes and no and n/a with radio buttons for each question.
I have created the buttons and the groups for each question but only one button can be selected at a time on the entire worksheet.
So when I answer the second question the selection for the first question clears.
I have been researching this for 2 days now and I am not having any luck. I am not skilled at coding can someone please help me?
I am attaching a blank version of the questionaire.


ULDD BUTTONS.xlsx

[walruseggman]

Why aren't the macros in the workbook? I see no code in the VBA viewer.

So it's kinda hard to say what the issue is because it looks like all of your radio buttons are trying to trigger the same OptionButton2_Click sub.

[Cdavies]

I didn't write any VBA code. I don't know how really. I don't know what you mean. I am completely lost here.