Scrolling of UserForm1

[frankosun]

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.

[Tom Ogilvy]

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" <frankosun@discussions.microsoft.com> wrote in message
news:778C2A0E-F178-4B75-91C5-A675F0789F9F@microsoft.com...
> 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.