Option Buttons on User Forms

I

ibeetb

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
 
B

Bob Umlas

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