Multi-tiered option selection in User form

[SeniorTom]

I'm trying to create a user form with 2 levels of selecting on the 1 form.

User can chose option ShotGunStart or TeeTimeStart. If they chose TeeTimeStart, then they can select 8,9 or 10 minute spacing.

o ShotGunStart
o TeeTimeStart
o 8 minute spacing
o 9 minute spacing
o 10 minute spacing

Currently, I can only select any 1 option. I can create 3 TeeTimeStarts, but want to learn if the 2 tier selection is possible.

You thoughts will be appreciated.

Regards,
Tom


EDIT: OOPs ... the format should have the 8,9,10 spacings indented.

 

[mikerickson]

You could create a userform with one Frame (Frame1) and two Option Buttons (OptionButton1 & OptionButton2).
Then put three more option buttons (OptionButton3, OptionButton4, OptionButton5) inside the frame.
Then put code like this in the userform's code module

Private Sub OptionButton2_Change()
    Frame1.Visible = OptionButton2.Value
End Sub

Private Sub UserForm_Initialize()
    OptionButton1.Caption = "ShotGunStart"
    OptionButton2.Caption = "TeeTimeStart"
    OptionButton3.Caption = " 8 min spacing"
    OptionButton4.Caption = " 9 min spacing"
    OptionButton5.Caption = "10 min spacing"
    Frame1.Visible = False
End Sub

 

[SeniorTom]

Sorry for the delay. I was working on another piece of my project. You pointed me in the right direction and I have got my user form working.
Thanks,
Tom