Userform Radio Buttons- how code this ?

[Pat_The_Bat]

I've designed a simple userform with 3 radio dial buttons, an OK and a Cancel button.

How do I write the code so that when a user chooses OptionButton 1, then hits OK, the operation I want to perform is performed.

I feel like I should be getting this more easily! Appreciate help and guidance.

 

[RoryA]

All you need is something like this:

   If OptionButton1 Then
' do some code
End If

 

[Pat_The_Bat]

Thanks Rory,

I guess the part I am struggling with is that the user clicks the radio button, then when user clicks "ok", nothing happens.

So I guess what I'm trying to do is let user choose which option, then click "OK", and once OK gets clicked, that's when I need that code to execute. Thoughts?

 

[Norie]

If you double click the OK button you should see something like this code stub, where CommandButton1 will be replaced with the name of the OK button control.

Private Sub CommandButton1_Click()

End Sub

This is where the code you want to be executed when the button is clicked should go.

For example, here's Rory's code added to the sub.

Private Sub CommandButton1_Click()
    If OptionButton1.Value Then
        ' do some code
    End If
End Sub

 

[Pat_The_Bat]

I did that. it still doesn't do anything when I hit the ok button on the userform
???

 

[Pat_The_Bat]

I've made some progress here. I went to the code associated with the OK button, and there I started with Me.hide, then put

If OptionButton1.Value Then
' do some code
End If

 

[My Aswer Is This]

Try this:

Private Sub CommandButton3_Click()
'Modified  5/16/2019  9:10:52 PM  EDT
If OptionButton1.Value = True Then
MsgBox "Yep Option Button One is True"
End If
End Sub

 

[DanteAmor]

I've made some progress here. I went to the code associated with the OK button, and there I started with Me.hide, then put

If OptionButton1.Value Then
' do some code
End

Why Me.Hide?


Just:

Private Sub CommandButton1_Click()

If OptionButton1.Value Then
        Msgbox "operation 1"
    End 

If OptionButton2.Value Then
        Msgbox "operation 2"
    End If

If OptionButton3.Value Then
        Msgbox "operation 3"
    End If
End sub

Just select one option and press ok button.

 

[My Aswer Is This]

I always like using True and False with Option Buttons

So if your going to use:

If OptionButton1.Value Then


What are you going to use if it's false
​

 

[DanteAmor]

I always like using True and False with Option Buttons

So if your going to use:

If OptionButton1.Value Then


What are you going to use if it's false
​

Optionbutton.value
or
optionbutton.value = true
is the same

Not Optionbutton.value
Or
Optionbutton.value = false
Is the same