Userform and scroll bars
 

Hi

I have a user form that I have added the vertical scroll bar to by using the
properties.
However , the scroll bar does not work..

Is there something else I need to do??

Thanks in advance!
Kimberly

Userform and scroll bars
 

Is any of the userform not visible? If not, then there would be nothing to
scroll to.

--
Regards,
Tom Ogilvy

"KimberlyC" wrote in message
...
Hi

I have a user form that I have added the vertical scroll bar to by using
the
properties.
However , the scroll bar does not work..

Is there something else I need to do??

Thanks in advance!
Kimberly

Userform and scroll bars
 

Hi KimberlyC;
For example:

Private Sub UserForm_Initialize()
' Vertical ScrollBar
Me.ScrollHeight = Me.InsideHeight * 3
' Horizontal ScrollBar
'Me.ScrollWidth = Me.InsideWidth * 3
End Sub

MP

"KimberlyC" a écrit dans le message de
...
Hi

I have a user form that I have added the vertical scroll bar to by using the
properties.
However , the scroll bar does not work..

Is there something else I need to do??

Thanks in advance!
Kimberly

Userform and scroll bars
 

Hi
I figured it out.. I changed the scroll height to match the form height and
that seemed to work...
"KimberlyC" wrote in message
...
Hi

I have a user form that I have added the vertical scroll bar to by using
the
properties.
However , the scroll bar does not work..

Is there something else I need to do??

Thanks in advance!
Kimberly