Option Buttons on User Forms

  • Thread starter Thread starter ibeetb
  • Start date Start date
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
 
Select Case True
Case Me.Opt1.Value
...
Case Me.Opt2.Value
...
Case Me.Opt3.Value
...
Case Me.Opt4.Value
...
End Select
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

nXn matrix creation 7
verify state of option button 3
option group to select report when button clicked 1
Refer to controls by group name. 2
DropDownList: Select item based on record? (newbie) 4
UserForm OptionButtons 3
more than 2 option buttons on a form 9
option button value error 5

Back
Top