Referencing Option Button Group?

**Jmoo** · 06-10-2010, 11:00 AM

Hey All,

I'm slightly new to using UserForms and Radio/Option buttons.

I have 5 option buttons on UserForm1 name oB1, oB2,oB3, oB4,oB5.

They all have a GroupName of "oBgroup".

Now when I select one of those buttons. Can I reference the group name and see which option is selected?

I have tried this within another CommandButton_Click function that is also on UserForm1

Private Sub CommandButton1_Click()
    MsgBox (UserForm1.oBgroup.Value)
End Sub

However, I get the error "Method or Data member not found"

I know, I'm just referencing it slightly wrong. Any help would be greatly appreciated!

Thanks,

Jay

**romperstomper** · 06-10-2010, 11:10 AM

You can use a Select Case statement:


Private Sub CommandButton1_Click()
    Select Case True
       Case oB1
          MsgBox "option1"
       Case oB2
          MsgBox "option2"
       Case oB3
          MsgBox "option3"
       Case oB4
          MsgBox "option4"
       Case oB5
          MsgBox "option5"
    End Select
End Sub