Radio Button

[helpexcel]

I want to put radio buttons into a form. What code do I need for the button code to only run when OK is selected? thanks.

 

[decadence]

Let's say you have 3 buttons which are frequencies, For you to use the OK button you would need to reference the buttons that are selected i.e. option button to say this frequency, then you would press OK which would reference which button is selected then call a macro based on that button

Example Code for the OK button

    If OptionButton1.Value = True Then
        Call Macro_Radio1Frequency
    ElseIf OptionButton2.Value = True Then
        Call Macro_Radio2Frequency
    ElseIf OptionButton3.Value = True Then
        Call Macro_Radio3Frequency
    End If

 

[helpexcel]

thanks!