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?
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?