hello,

I really need help about this.
Capture.JPG

So what needs to be done is that:
If 1 is selected other 1's cannot be selected even the 2-7 anymore.
e.g. Work schedule: my choice is 1 then I cannot have another 1 to
Environment/Peers
Rewards and Recognition
Immediate Supervisor
Location
Compensation & Benefits
Career Growth

and no 2,3,4,5,6,7 optionbutton anymore(Work schedule)

Previously I used checkbox with a code of something like this:
*by the way I previous have like 150 check boxes and I did this for each one I ended up with a 14mb file*

Private Sub CheckBox89_Click()
With CheckBox89
.Caption = IIf(.Value = True, "10", "10")
If CheckBox89 = True Then
TextBox27 = "10"
CheckBox69 = False
CheckBox70 = False
CheckBox59 = False
CheckBox99 = False
CheckBox109 = False
CheckBox119 = False
CheckBox129 = False
CheckBox139 = False
CheckBox149 = False
CheckBox80 = False
CheckBox81 = False
CheckBox82 = False
CheckBox83 = False
CheckBox84 = False
CheckBox85 = False
CheckBox86 = False
CheckBox87 = False
CheckBox88 = False
End If
End With
End Sub


I even tried to use optionbutton that's inside a frame and I won't work as I wanted it to be done.
I really don't know what to do anymore.
I hope somebody can help me out.
Any ways that the codes for the checkboxes can be shortened?
Any kind of help will be much appreciated. Thanks!