UserForm Optionbutton

[excel_help_101]

hello all,
I am looking for a way so when i open up a userform data in a activecell will tell an optionbutton to be true, but I can get it to work

this is the code i am stying to work with

Sub Button1_Click()
Application.Visible = False
UserForm1.Show
If ActiveCell.Formula("N2") = "1" Then
OptionButton1 = True
End If
End Sub

thanks

 

[CodeNinja]

Good morning,
By the description of what you want, I would add an event to your userform...

Private Sub UserForm_Activate()
If ActiveCell.Value = "1" Then
    OptionButton1.Value = True
End If

End Sub

This will cause optionbutton1 to be selected if the active cell is 1 at the time the user opens the form.

 

[excel_help_101]

thanks thats just what i was looking for
thanks again!!!