Userform/Multiple Listboxes - Mirror Scroll Position

powera86 · Oct 16th 2012

Hi there,

I have a userform with multiple list boxes displaying data that correlate to eachother (i.e. the 2nd row of listbox1 and the 2nd row of listbox2 represent separate fields for the same data (ex. listbox1 one has firstname, listbox2 has lastname).

What I am wondering about, is whether there is a way to match the scroll activity from one listbox to another listbox, so that relevant information is display together. So if I scroll to the 43rd first name in listbox1, the 43rd last name will be lined up in the second list box automatically.

Thanks!

cytop · Oct 16th 2012

Re: Userform/Multiple Listboxes - Mirror Scroll Position

If it's not too late in the development cycle of your project, wouldn't it make more sense to have a multi-column listbox...?

powera86 · Oct 16th 2012

Re: Userform/Multiple Listboxes - Mirror Scroll Position

Absolutely...thought of that literally right after I posted the question. Duh... :smash:

Thanks Cytop

cytop · Oct 16th 2012

Re: Userform/Multiple Listboxes - Mirror Scroll Position

If you ever really feel the need - or for future reference...

A userform with 3 listboxes; L1, L2 & L3

Code

Private Sub l1_Click()
 
    l2.ListIndex = l1.ListIndex
    l3.ListIndex = l1.ListIndex
 
End Sub
 
Private Sub l2_Click()
 
    l1.ListIndex = l2.ListIndex
    l3.ListIndex = l2.ListIndex
 
End Sub
 
Private Sub l3_Click()
 
    l1.ListIndex = l3.ListIndex
    l2.ListIndex = l3.ListIndex
 
End Sub

Display More

powera86 · Oct 16th 2012

Re: Userform/Multiple Listboxes - Mirror Scroll Position

Much appreciated

Userform/Multiple Listboxes - Mirror Scroll Position

Participate now!

Share