Select Case True
Case Me.Opt1.Value
...
Case Me.Opt2.Value
...
Case Me.Opt3.Value
...
Case Me.Opt4.Value
...
End Select


"ibeetb" wrote in message
...
If I have 4 option buttons on a user form withing a frame (which makes
them
mutually exclusive), what kind of code can I write to tell me which option
button was pressed. Assume that they are named: opt1, opt2, opt3, opt4

Thanks