-
vertical scroll bar not working
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:
[VBA]Private Sub UserForm_Initialize()
RiskForm.ScrollBars = fmScrollBarsVertical
End Sub
[/VBA]
Is there something else I need to do to enable the scroll bar?
-
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.
-
Thanks Nate. That worked.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules