Scrolling a frame at the same time as scrolling a listbox

[Becks]

I have a Listbox showing 12 items but contains more (19 now). I have a frame which contains 19 text edit boxes, such that when a Listbox item is selected then the matched text box becomes visible ready for data entry so that the text box can be updated. The frame overlays the Listbox (Frame1.ZOrder 0)
When I scroll the listbox I want the frame to also scroll. I can do the scroll but only by capturing the MouseMove event of the Listbox, determining the TopIndex of the Listbox and then setting the ScrollTop of the Frame - very clunky because the Listbox scrollbar is not part of the region that the MouseMove event covers and the mouse has to move from the scrollbar into the Listbox before the Frame can be updated. Is there a solution? (I can live with clunky though).
Alternatively is there a scrollbar control that behaves in the same way as the list box scroll bar that I could overlay the listbox scrollbar and pass the scroll bar's movements to both the Listbox and the Frame. The scroll bar would have to show the position and the relative portion displayed which isn't how the Forms scrollbar behaves.

[HansV]

Instead of a list box, I'd use the frame only, with a series of check boxes and text boxes. Ticking a check box makes the corresponding text boxes visible.
This would get rid of the problem of trying to synchronize a list box and a frame.

[Becks]

Thanks Hans
That would probably solve my previous problem as well, although the Listbox appeals because it has 5 columns containing data and resizes itself to the number of rows of data in the workbook. In the past, I have built forms that have added controls at run-time so it is possible...

[Becks]

As a follow-up, I was able to cobble together scrollbar similcrum consisting of three command buttons inside a frame that worked passibly before I "blew up" my Excel session (first time I have got a 'Catastrophic failure' message - normaly Excel crashes without such dignity ) although I hadn't resolved my previous error of disappearing highlights. I followed your suggestion and implemented a class of checkbox, labels and text edit box added inside a frame (thanks JKP for your code http://www.jkp-ads.com/Articles/ControlHandler01.asp)
Regards and

[HansV]

Glad that uou got it working!