scrolling 2 frames simultaneously

[noname]

Hi,

I have written code to autogenerate textboxes in 2 frames on an Excel
Userform.
the upper frame has disabled autogenerated textboxes arranged in
columns.
the lower frame has enabled autogenerated textboxes, again arranged in
columns.
both frames have horizontal scrollbars.

what i want to do is that when i load the form, i should have the
ability to scroll both the frames together, so that the upper disabled
textboxes are in perfect sync (same column) as the lower frame
textboxes. e.g. if i move the upper frame scrollbar, the lower frame
scrollbar should also move simultaneously.

is there a change event associated with a Frame scrollbar?

Any ideas, how this can be done?

 

[noname]

Hi,

I have written code to autogenerate textboxes in 2 frames on an Excel
Userform.
the upper frame has disabled autogenerated textboxes arranged in
columns.
the lower frame has enabled autogenerated textboxes, again arranged in
columns.
both frames have horizontal scrollbars.

what i want to do is that when i load the form, i should have the
ability to scroll both the frames together, so that the upper disabled
textboxes are in perfect sync (same column) as the lower frame
textboxes. e.g. if i move the upper frame scrollbar, the lower frame
scrollbar should also move simultaneously.

is there a change event associated with a Frame scrollbar?

Any ideas, how this can be done?

Please note that the 2 frames are on an Excel Userform and both have
their Horizontal scrollbars visible & active.
Please also let me know how to adjust the scrollbar.Width &
scrollbar.Left properties, so that the last controls is completely
visible (i.e. the controls .Left is in line with the frame's right-end
side.

 

[noname]

Please note that the 2 frames are on an Excel Userform and both have
their Horizontal scrollbars visible & active.
Please also let me know how to adjust the scrollbar.Width &
scrollbar.Left properties, so that the last controls is completely
visible (i.e. the controls .Left is in line with the frame's right-end
side.

Sorry, i meant the last control's right-end (inside both frames) is in
line with the frame's right-end. so the last textboxes controls inside
both frames appear fully visible without any gap between their end and
the frame's end.)