Sounds like you are UnLoading the userform, or allowing the user to dismiss
it with the close button, instead of using the Hide method to keep it in
memory. This means that control values are lost.

You can disable the Close button (the x in the top right of the form) by
trapping the QueryClose event and cancelling it by setting Cancel = True.
Force the user to use your own OK or Cancel button and use the Hide method
to close the userform.

John Green

"rohnds " wrote in message
...
I have user form with three option button so that the user can select
one of the options.
How can I store the returned value in a variable?


Sub test()
Dim f1, f2, f3 As Boolean
UserForm1.Show
f1 = UserForm1.OptionButton1.Value
f2 = UserForm1.OptionButton2.Value
f3 = UserForm1.OptionButton3.Value
MsgBox f1 & f2 & f3
End Sub


Evertime I run this procedure I always get False, False, False (ie the
value set the properties section of the optionbutton).
I found a way to return the True if I select an option and false when I
didn't but setting the ControlSource option of the properties section
to cell.
Is there a way I could get True when I select the optionand False when
I don't wihtout setting the ControlSource to a cell, since then I have
to have another Sheet that contains only the values from these
optionsbuttons.


---
Message posted from http://www.ExcelForum.com/