Help required-List boxes -2

[Raymond_India]

I have 4 listboxes on a form. They all contain data from a spreadsheet. The data is quite extensive (say 2000 rows) All the listboxes have scrollbars on the right hand side which means that all list boxes can be scrolled up and down. Unfortunately if only one list box is scrolled and the rest is not scrolled along with it, the data that is displayed loses it relevance because of the simple fact that it will not relate to the data on the corresponding listbox.<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o></o>
What i want is, a macro that would move the scrollbars of all 4 listboxes simultaneously in a sychronised fashion so that when the scroll bar of listbox1 is moved up or down, the other list boxes also changes accordingly<o></o>
<o></o>
(Just think of a billing clerk in a supermarket scrolling through an an invoice on a computer screen, all the relevant colums scroll together right, thats exactly what i want)<o></o>
<o></o>
Please revert if my question is not clear. I'll try to reframe it in a different way.<o></o>
<o></o>
Thanks<o></o>
<o></o>
Ray<o></o>

 

[xld]

How odd, a guy gave this technique in the lounge recently, http://www.mrexcel.com/forum/showthread.php?t=429815. It is post #4 by hatman

 

[mikerickson]

It sounds like a single listbox with 4 columns might be an idea.

The difficulty with the 4 LB approach is detecting when the scroll bar is scrolled.