Scrollbar settings

  • Thread starter Thread starter Allison
  • Start date Start date
A

Allison

I have a scrollbar and want to set the slider to start off in the centre or
on the right hand side when I launch the form. How do I do this in VBA?

Thanks for any help.
Al
 
Maybe something like will give you an idea:

Option Explicit
Private Sub UserForm_Initialize()
With Me
.ScrollBars = fmScrollBarsVertical
.ScrollHeight = 2 * .Height
.ScrollTop = 2 / 3 * Height
End With
End Sub
 
Back
Top