Determine Option Button Selected

[Rocky0201]

Hi folks...

In my Private Sub CommandButton1_Click() routine, I need to determine which OptionButton of the 48 OptionButton's was selected.

Is the an way to may this determination?

Thanks

 

[shg]

Are these controls on form or on a worksheet?

 

[cstimart]

Hi folks...

In my Private Sub CommandButton1_Click() routine, I need to determine which OptionButton of the 48 OptionButton's was selected.

Is the an way to may this determination?

Thanks

Something like this? Untested

Private Sub CommandButton1_Click()
Dim oButton As Control
Dim i As Long
Dim answer As Long

For i = 1 To 48
    Set oButton = Me.Controls("OptionButton" & i)
    
    If oButton.Value = True Then
        answer = i
        Unload Me
        Exit Sub
    End If
Next i
End Sub

 

[Rocky0201]

Thank you shg and cstimart.

cstimart, I used your example and it worked great!!!