Populating drop down boxes again

[Tark221]

Private Sub ComboBox1_Change()

'If Candice is picked in box one then
'her team will populate box to the right

Me.ComboBox3.Value = ""
If Me.ComboBox1 = "Candice Smith" Then
Me.ComboBox3.RowSource = "=Smith"
Me.ComboBox3.Value = ""

End If
End Sub

This works but how would i say add other options other than candice
I have a list of people i need to add to this statement but i don't know how to write
it, i know its the same code as above but i dont know what needs to be between them like else if etc

thanks

 

[Tark221]

I some how manage to solve my own questions bah, sorted it