combobox question

[Bri]

I'm new to comboboxes and need a few clues.

I have Combobox1 that lists 3 dates. Combobox2 lists the names of
volunteers.

I want to be able to make many selections from combobox2 to produce a LIST
of volunteers (not just change the value of 1 cell). If the 1st, 2nd or 3rd
date is selected, the list of volunteers starts should start in C5, E5 or G5
respectively.

Could one of you gurus point me in the right direction?

Thanks in advance
Bri

[dok112]

this should work for you


Private Sub ComboBox1_Change()
Select Case ComboBox1.Value
Case "date1" 'change to first date
ComboBox2.RowSource = "=Sheet1!C5:C15" ' change to source of new data
Case "date2" 'change to second date
ComboBox2.RowSource = "=Sheet1!E5:E15" ' change to source of new data
Case "date3" 'change to 3rd date
ComboBox2.RowSource = "=Sheet1!G5:G15" ' change to source of new data
End Select
End Sub