Hello,
Is it possible to select one OptionButton and deselect the other?
Because i can't make it work it keeps them all selected
in my frameControl
Private Sub Chk_Click()
Dim ctl As MSForms.control
For Each ctl In Chk.Parent.Controls
If TypeName(ctl) = "OptionButton" Then
With ctl
If .Name = Chk.Name Then
If .Value = True Then
.Value = False
Else
.Value = True
End If
End If
End With
End If
Next ctl
End Sub
Thanks