Mirror User Form Scroll bar to Active Sheet Scrolling standard scroll bar

Excelhorizontal

New Member
Joined
Sep 11, 2014
Messages
1
I have a userform that acts as a toolbox for editing data that comes in regulary in excel sheets. All of the editing to the sheet is done through buttons/macros on the form. Currently there are two buttons for scrolling the sheet on the form so that the user doesn't have to go all the way to the bottom of the screen to scroll (the user form loads at the top of the screen). Here is the code that is currently being used for a left and right arrow buttons:

Private Sub LeftArrow_Click()
ActiveWindow.SmallScroll ToRight:=-2
End Sub

Private Sub RightArrow_Click()
ActiveWindow.SmallScroll ToRight:=2
End Sub

What I want is to put a scroll bar on the user form that simply mirrors the active sheets scroll bar. Is this even possible?
 

Excel Facts

How to create a cell-sized chart?
Tiny charts, called Sparklines, were added to Excel 2010. Look for Sparklines on the Insert tab.

Forum statistics

Threads
1,224,416
Messages
6,178,510
Members
452,853
Latest member
philipnjk64

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top