Selecting only one combobox

[Jaz05]

Hi,

I have a user form in which I want the user to have ONE of two choices ...
ComboBox1 = choice of Round
OR
Combobox2 = choice of Club

If they choose from the rowsource of ComboBox1 (Round) then ComboBox2 (Club) is disabled.

If they choose from the rowsource of ComboBox2 (Club) then ComboBox1 (Round) is disabled.

If they choose Combobox1 AND Combobox2 then the last choice they made, clears the previous data.

When they choose OK, then depending on which choice the user made, will depend where the form takes them ... to sheet Round or sheet Club


I'm feeling like a 40-year-old VBA Virgin.

 

[Andrew Poulsom]

What I would do is add a couple of OptionButtons with the ComboBoxws alongside them. Sample code:

Private Sub UserForm_Initialize()
    OptionButton1.Value = True
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

Private Sub CommandButton1_Click()
    If OptionButton1.Value = True Then
        MsgBox "ComboBox1 to be used"
    ElseIf OptionButton2.Value = True Then
        MsgBox "ComboBox2 to be used"
    End If
End Sub

 

[Jaz05]

Andrew,

Thank you - brilliant.