Syncing Two Horizontal ListBox ScrollBars in Excel 1

[Westy73]

Hi,

I have a form in an Excel application that contains two(2) listboxes. Both listboxes are the same width, have the same number of columns and column widths and both have horizontal scrollbars.

Is there anyway, to sync the horizontal scrolling so that moving one(1) of the horizontal scrollbars actually controls the horizontal movement of both list boxes?

Thanks.

 

[TonyJollans]

Hi Westy73,

The short answer is No. VBA does not provide any hooks into listbox scrolling - you can neither tell when it happens nor make it happen.

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[Westy73]

I suspected as much.
Thanks for your help Tony.

 

[HalfListener]

If sync is important, why not create a single double-wide listbox with two grouped columns of data?