Change properties of a userform
Hi Mike,
maybe I didn't understand your question, but you don't need to use:
Private Sub OptionButton1_Click()
Me.OptionButton1.Value = True
End Sub
to change the value of optionbutton. It changes automatically,
including unchecking all the other optionbuttons in the same
form/tab/frame.
If you need to set value of the optionbutton before you show the
userform to the user, use something like this:
with userform
..optionbutton1.value=true 'sets the default = checked optionbutton1
..show
end with
Regards,
Ivan
Mike Archer wrote:
Hello -
How do you programically change an optionbutton value permenatly. I want
the default value for an option button to be true every time the userform is
ran after the user selects that optionbutton. I thought that you could just
set it to true when it was checked... Like this:
Private Sub OptionButton1_Click()
Me.OptionButton1.Value = True
End Sub
Private Sub OptionButton2_Click()
Me.OptionButton2.Value = True
End Sub
Private Sub OptionButton3_Click()
Me.OptionButton3.Value = True
End Sub
But it always goes back to the one that I set to true in the properties.
It's probably easy, but I can't figure it out (other than storing the
selection on the workbook and referencing it in the initialization event -
pretty sloppy, I know).
--
Thanks,
Mike
|