Excel VBA Combo Box Populating dependent on other combo box choices

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?

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?
>
>