I want to scroll the screen using the toolbox scrollbar, any ideas?

[Badassack]

I'm using a form so theres no way to scroll down the screen while in the form. So i thought why can't you use the toolbox scroll bar on the form to scroll up and down the worksheet. I would love some ideas, i can't find anything on the net about this. thank you.

 

[RoryA]

Simple example:

Private Sub ScrollBar1_Change()
   ActiveWindow.ScrollRow = ScrollBar1.Value
End Sub

Private Sub UserForm_Initialize()
   With Me.ScrollBar1
      .Min = 1
      .Max = ActiveSheet.Rows.Count
   End With
End Sub

It would probably be easier just to make the form modeless.

 

[Badassack]

Simple example:

Private Sub ScrollBar1_Change()
   ActiveWindow.ScrollRow = ScrollBar1.Value
End Sub

Private Sub UserForm_Initialize()
   With Me.ScrollBar1
      .Min = 1
      .Max = ActiveSheet.Rows.Count
   End With
End Sub

It would probably be easier just to make the form modeless.

It would't work the way you wrote it. gave me an ambiguous name error. Was i supposed to use one or the other? I combined the two codes and it work's, thanks.

Private Sub scbauto_Change()
ActiveWindow.ScrollRow = scbauto.Value
With Me.scbauto
.Min = 1
.Max = ActiveSheet.Rows.Count
End With


End Sub

 

[RoryA]

I guess you already had a Userform_Initialize event then.