Optionbutton

[serenitylai]

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!

[Norie]

Any chance you could upload a sample workbook?

Click on GO ADVANCED, scroll down and click Manage Attachments.

[serenitylai]

not sure why but it's saying
sample2.xlsm - Upload of file failed.
I'll try it again.

[serenitylai]

Sorry I really tried I even reduced the size of the sample file to 3mb but i'm still getting this:
Capture.JPG

[serenitylai]

here's a sample file