+ Reply to Thread
Results 1 to 10 of 10

userform scrollbar not working

  1. #1
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    userform scrollbar not working

    hi all, I have a userform, within the form I have about 20 textboxes, I have set the userform to have a vertical scrollbar, but it does not seem to work,
    any ideas?

    scouse13

  2. #2
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: userform scrollbar not working

    Did you add the scrollbar from the tools? If so, remove it then do this..
    In the VBA editor window -
    Click on the UserForm
    in the UserForm Properties window -
    Set ScrollBars to 2
    ScrollTop to 0
    and ScrollHeight to a number that is larger than the height of the UserForm
    So if the height of the userform is 100, change the ScrollHeight to 200
    1N73LL1G3NC3 15 7H3 4B1L17Y 70 4D4P7 70 CH4NG3 - 573PH3N H4WK1NG
    You don't have to add Rep if I have helped you out (but it would be nice), but please mark the thread as SOLVED if your issue is resolved.

    Tom

  3. #3
    Forum Contributor
    Join Date
    06-27-2014
    Location
    bristol, england
    MS-Off Ver
    excel 2007
    Posts
    264

    Re: userform scrollbar not working

    Quote Originally Posted by gmr4evr1 View Post
    Did you add the scrollbar from the tools? If so, remove it then do this..
    In the VBA editor window -
    Click on the UserForm
    in the UserForm Properties window -
    Set ScrollBars to 2
    ScrollTop to 0
    and ScrollHeight to a number that is larger than the height of the UserForm
    So if the height of the userform is 100, change the ScrollHeight to 200
    thanks a lot. I have sat here for hours baffled as to why it was not working, thanks a lot
    scouse13

  4. #4
    Forum Expert gmr4evr1's Avatar
    Join Date
    11-24-2014
    Location
    Texas
    MS-Off Ver
    Office 2010 and 2007
    Posts
    3,448

    Re: userform scrollbar not working

    You're welcome. I did something similar last night. I worked on something for a few hours, couldn't get it figured out so I finally came on here to ask for help. Within minutes, bakerman2 posted a solution for me. I need to just start coming here right away lol.

  5. #5
    Registered User
    Join Date
    05-08-2024
    MS-Off Ver
    2019
    Posts
    1
    Quote Originally Posted by gmr4evr1 View Post
    Did you add the scrollbar from the tools? If so, remove it then do this..
    In the VBA editor window -
    Click on the UserForm
    in the UserForm Properties window -
    Set ScrollBars to 2
    ScrollTop to 0
    and ScrollHeight to a number that is larger than the height of the UserForm
    So if the height of the userform is 100, change the ScrollHeight to 200

    Thank youuuuuuuu... from year 2024!

  6. #6
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,861

    Re: userform scrollbar not working

    I would change your location entry to your location, unless you want lots of SPAM in your inbox ...
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    NB:
    as a Moderator, I never accept friendship requests.
    Forum Rules (updated August 2023): please read them here.

  7. #7
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,052

    Re: userform scrollbar not working

    I have removed your email from your profile. Please do not include personal information on a public forum like this.
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,861

    Re: userform scrollbar not working

    @FDibbins

    It's still visible ...

  9. #9
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    53,052

    Re: userform scrollbar not working

    I just refreshed and its not there?

    Maybe it took a few minutes to take effect.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (both in England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2507 (Windows 11 Home 24H2 64-bit)
    Posts
    91,861

    Re: userform scrollbar not working

    Gone now.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. userform scrollbar in textbox
    By scouse13 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2020, 01:13 AM
  2. Scrollbar on Userform
    By DonJuan85 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 07-06-2015, 02:41 PM
  3. [SOLVED] Userform Scrollbar Value
    By eikert78 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-02-2013, 12:22 PM
  4. userform is large.....how to use scrollbar of userform to show all of the userform
    By welchs101 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-05-2010, 04:11 PM
  5. Scrollbar on a Multipage UserForm
    By skysurfer in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-24-2010, 03:30 PM
  6. Please help! Scrollbar in Userform
    By bimmerman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 07-25-2007, 02:39 AM
  7. Userform Scrollbar
    By Stuart in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-22-2005, 07:06 PM

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