Checkbox to control Combobox ListSource?

[thenapolitan]

Hey All,

I am making a scoring sheet and new at learning VBA, so this might be a little out there, but I'm not sure if I can do it yet.

The userform I have has comboboxes where the user can select a team. When a team is selected, the player names are automatically chosen.

I would like to add a checkbox next to the combobox. I want the user to be able to click the checkbox if there is a substitute player, then view names from a different ListSource (where subs are stored) in the combobox.

Is this possible? See below for my userform - I haven't been able to find anything in my *googling* - any help would be great! Any questions, let me know!

Thanks,

Chris

 

[mikerickson]

You could use code like this

Private Sub CheckBox1_Click()
    If CheckBox1.Value Then
        ComboBox1.List = Range("otherRange").Value
    Else
        ComboBox1.List = Range("normalRange").Value
    End If
End Sub

 

[thenapolitan]

You could use code like this

Private Sub CheckBox1_Click()
    If CheckBox1.Value Then
        ComboBox1.List = Range("otherRange").Value
    Else
        ComboBox1.List = Range("normalRange").Value
    End If
End Sub

Excellent! Thanks mikerickson for helping out a newb! This is getting me exactly where I want to go