Listbox linking

[khur_chesk]

I have two listboxes, each having items based on same criteria, meaning two column values in the respective listboxes of the same row, now if i highlight item of listbox1 it should also highlight its corresponding item in listbox 2, How am i suppose to do that?

 

[Norie]

Add code for the first listbox to set the selected value of the second listbox the same as the first.

Private Sub Listbox1_Change()

     If Listbox1.ListIndex<> -1 Then
           Listbox2.ListIndex =  Listbox2.ListIndex
     End If

End Sub

 

[khur_chesk]

It Didnt worked, nothing seem to change after the addition of the code.

 

[khur_chesk]

Ive got it working, Thx a lot...