+ Reply to Thread
Results 1 to 3 of 3

Scroll bars in an Excel userform

  1. #1
    Registered User
    Join Date
    11-11-2009
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    1

    Scroll bars in an Excel userform

    Here's a tricky one. I have a user form controlled by a macro, but when some users with a low res 800 x 600 screen use it, the bottom of the form is cut off.
    I can add a Scroll Bar control that has a slider box, but how do I make the Scroll Bar properties move the view downwards to bring the lower portion of the form into view?

  2. #2
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,342

    Re: Scroll bars in an Excel userform

    Hey Shamus
    It can be done if you frame the all the controls and use a scroll bar to reposition the frame up.
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs

  3. #3
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,482

    Re: Scroll bars in an Excel userform

    This will halve the height of your userform and add a vertical scroll.

    Please Login or Register  to view this content.
    Cheers
    Andy
    www.andypope.info

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1