Scrolling of UserForm1
 

Hi there,

i have one problem, i cannot understand using of scrollbar in vb in excel.
I have one userform which is bigger then my screen and i need to put in this
form scrollbar and use it for moving my userform to see all things on it. Can
anyone help me? Thanx a lot.

Scrolling of UserForm1
 

Try putting code like this in your Initialize event.

Private Sub UserForm_Initialize()
Dim lh As Long
Me.ScrollBars = fmScrollBarsVertical
lh = Me.Height
Me.ScrollHeight = lh
Me.Height = Me.Height / 2
End Sub


Then play with it to get what you want.

--
Regards,
Tom Ogilvy


"frankosun" wrote in message
...
Hi there,

i have one problem, i cannot understand using of scrollbar in vb in excel.
I have one userform which is bigger then my screen and i need to put in
this
form scrollbar and use it for moving my userform to see all things on it.
Can
anyone help me? Thanx a lot.