Select Case Combobox1.ListIndex
case 0

case 1

case 2

case else

end Select

this assumes a combobox from the control toolbox toolbar.

--
Regards,
Tom Ogilvy


"ikabodred" wrote:

I am trying to populate a combo box that is dependent on another combo
box selection. I currently trying to use a "Select Case
comboBox1.value", "Case 1, Case 2.....Case N", and I am referenceing
the list index of the selection in the independent combo box to be the
case number in the "comboBox1.value" case. This is not working. Can
anyone help me out?