Scroll textbox if the adjacent is scrolled

Hi forum, I have another questions about textboxes.

I'm trying to create a userform to insert data in a worksheet.
The user has to choose a macro-category and add multiple items (read lines of data) for such categorized list, I store the data in multiline textboxes to allow the user to complete the data entry and still view all the lines entered.
Since the lines for each data entry may be more than I can show in the textbox window I opted to set the scrollbars to vertical to allow the user to scroll through the lines.
The functioning is fine, but I would want the adjacent textbox to scroll as well when the user trigger one of them..is this possible? Would it be possible even if I had more than one textbox to update? Listboxes best suit this achievement?

I attach a dummy worksheet which was updated with the previous thread resolved by RoyUK and another increment sub I created.

thanks again for your help
P.

If you use a listbox you can make it multi-column which (of course) all scroll together. Therefore doing away with multiple controls.

Does this answer your need?

Try this way

Updated to show how to use the Listbox selections

Hi RoyUK,
thanks for your support.
Your code works fine but when I try to implement it for my needs I still have something to tweak.
I set the Userform Initialize Sub like this:

Please Login or Register  to view this content.

And the InsertData Sub like this:

Please Login or Register  to view this content.

Even though I set the columns to 5 I can see only 4 data per listbox row.
At first I set the first .Listbox.List(ref - 1,1) = ListBox.ListCount + 1 but then I noticed the Sub already add the line num with the ref variable in .ListBox.AddItem

In brief, what I get now is that I can't see displayed the amount calculated in the last ListBox.List row.
Furthermore the 1st column of the ListBox is way larger than I want it to be, so the others..somehow it happens the .ColumnWidths property is not read correctly, isn't it?

Last thing: is there a way to temporarily 'disable' the Subs invoked with Change on Hours and HourPay when I clear all the textboxes at the end of the InsertData_Click Sub? How can I change those Subs?

thanks again for your help,
P.

I've amended your code and set the width manually using the ColumnWidth Property,they need tweaking a little