If an option button is clckd then show another group option

[KJ]

Please help!

I'm using MS Excel 97.

I have a group option box of a number of teams ie the first one is Team 1 all the way to Team 9. If Team 1 is clicked I would like another group option box to appear with the Team 1 members and if Team 2 is clicked I would like their members to appear.

As I am unfamiliar with VBA I am finding this quite difficult.

I'm sure there is a genius out there who know's the answer.

Many thanks

KJ

 

[Andrew Poulsom]

Re: If an option button is clckd then show another group opt

That's possible, but I think your UserForm would look better if you use ComboBoxes for the team members alongside your OptionButtons. then you can toggle theie Visible property depending on which OptionButton is selected. Example:

Private Sub UserForm_Initialize()
    OptionButton1.Value = True
    ComboBox1.Visible = True
    ComboBox2.Visible = False
End Sub

Private Sub OptionButton1_Click()
    ComboBox1.Visible = True
    ComboBox2.Visible = False
End Sub

Private Sub OptionButton2_Click()
    ComboBox1.Visible = False
    ComboBox2.Visible = True
End Sub

 

[KJ]

Re: If an option button is clckd then show another group opt

WOW!

Andrew - that was fast work!

Thankyou for this - I'll give it a go.

Have a fantastic weekend.

KJ