PDA

View Full Version : vertical scroll bar not working



talytech
11-21-2008, 02:07 PM
I have a UserForm that goes beyond the Workbook window. I have a vertical scroll bar but it doesn't let me scroll up and down. THis is the code that I have to display it:

Private Sub UserForm_Initialize()
RiskForm.ScrollBars = fmScrollBarsVertical
End Sub


Is there something else I need to do to enable the scroll bar?

nst1107
11-21-2008, 02:32 PM
Here's a suggestion: set the userform scrollheight to whatever the height of your userform is now, then resize the userform so that it fits within the window.
Scrolling in a userform doesn't work quite like you might think it does. Only the zoom area moves when you move scrollbars--the userform's frame stays in place.

talytech
11-24-2008, 07:42 AM
Thanks Nate. That worked.