Consulting

Results 1 to 3 of 3

Thread: vertical scroll bar not working

  1. #1

    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?

  2. #2
    VBAX Tutor nst1107's Avatar
    Joined
    Nov 2008
    Location
    Monticello
    Posts
    245
    Location
    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.

  3. #3
    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
  •