Synchronising the scrolling of two ActiveX listboxes .

[Jaafar Tribak]

I guess this could be achieved by starting a loop/timer upon the ListBox receiving the focus and setting the ListBox TopIndexes then exiting the loop when loosing focus but I was wondering if there is a workaround this w/o using a loop to avoid potential problems.

 

[GlennUK]

Hi Jaafar,

nice to see you on here again .... a question: why have 2 listboxes like that? Are they going to be side by side? Are they going to contain the same data, or different data?

Not that I have any ideas at this point, I was just wondering why you weren't thinking of having a single multicolumn listbox.

 

[Jaafar Tribak]

Thanks for responding Glenn.

The listboxes are going to be side by side . different data but related - for instance ListBox1 contains Country names and Listbox2 contains their respective capital cities.

The reason I wanted to have them seperated is because they have a linked cell each which will not work for multicolumn listboxes but I think that the multicolumn solution you suggested is the way to go i'll will just have to update the linked cells via code.

However , even using a single multicolumn listbox is going to be tricky as there is no Scroll event.

 

[GlennUK]

If you have a multicolumn listbox, the linked cell will give the leftmost item when a choice is made. You can generate the associated capital city with a formula, surely?