selection in comboboxes based on criteria

[kelly mort]

Hello All,
I have two comboboxes combobox1 and combobox2 and wants to select in the second one as below: when i select the first item in the combobox1, select the first item in the combobox2. When i select second item in cmb1, select the second item in cmb2 and so on. Thanks.
Kelly

 

[kelly mort]

Bump

 

[dmt32]

Try

Private Sub ComboBox1_Change()
    Me.ComboBox2.ListIndex = Me.ComboBox1.ListIndex
End Sub

Dave

 

[kelly mort]

Yess!!! Thank you very much. Mission successful
Kelly