UserForm toggle buttons to populate a cell (named Range)

[gheyman]

I have a userForm (userform1) that has three grouped toggle buttons OptionButton1, OptionButton2 and OptionButton3
I also have a button on the form.

After the user selects one of the toggles and clicks the button I want to be able to populate a cell on one of my tabs (with a value based on which button is selected)

Sheet1.Range("PartListType")

OptionButton1, value = "Buyer Generated"
OptionButton2, value = "PBoM List"
OptionButton3, value = "Open Requisitions"


Any help is appreciated! Thanks!

 

[gheyman]

Resolved

Private Sub CommandButton1_Click()

If OptionButton1.Value = True Then
        Range("PartListType").Value = "Buyer Generated"
        IdentPartID.Hide
    Else
If OptionButton2.Value = True Then
        Range("PartListType").Value = "PBoM List"
        IdentPartID.Hide
    Else
If OptionButton3.Value = True Then
        Range("PartListType").Value = "Open Requisitions"
        IdentPartID.Hide
    Else
    
    MsgBox "You Must Select one of the three options above"
    
End If
End If
End If
    

'PLType_Submit


End Sub