Multiple Option Buttons in Userform

I am creating a survey type userform with multiple groups of Yes, No, N/A questions.

With yes and no alone i can use

If OptionButton1.Value = True Then
Cells(emptyRow, 2).Value = yes"
Else
Cells(emptyRow, 2).Value = "no"
End If

but what would i use if i have 3 options?

Thanks in advance for all the help

Please Login or Register  to view this content.

Alternatively...

Please Login or Register  to view this content.

Option buttons are TRUE/FALSE by nature so there is really only 2 options you have available with using 1 option button. As Poizhan eluded to, you could use multiple option buttons to give you more options (i.e. TRUE/TRUE, FALSE/FALSE, TRUE/FALSE, FALSE/TRUE). However, there are a lot many other (better) options available to you such as a combobox. If you still would like to use the option button then it might be best to use 3 buttons per survey (yes,no,n/a) and have it set to where you can only select one option. If you want help with code submit your workbook.

Multiple option button groups is not ideal

Thank you for all the help :D

what if i use 4 radio button and i want to be upload selected data in specific excel cell