Scrollbar settings

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
 
D

Dave Peterson

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
 
Top