+ Reply to Thread
Results 1 to 4 of 4

Userform Scroll bar - can I make it autoscroll?

  1. #1
    Registered User
    Join Date
    02-19-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2013
    Posts
    69

    Userform Scroll bar - can I make it autoscroll?

    I have a user form that exceeds the visible field, so I added a vertical scroll bar. The only problem is (and it's not a big one, but I don't like it) is that as I near the bottom of the form I have to click and drag the scroll bar to move it down so I can finish the rest of the form. Is there a code that I can use to make it automatically move down as I progress through the form? I've looked around a bit online and can only find how to add a scroll bar, but not really anything useful in regards to automating the scroll bar.

    Many thanks in advance

  2. #2
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Userform Scroll bar - can I make it autoscroll?

    I have created a very rough Sample User Form For you.

    I will tidy it up and repost it.
    Attached Files Attached Files
    My General Rules if you want my help. Not aimed at any person in particular:

    1. Please Make Requests not demands, none of us get paid here.

    2. Check back on your post regularly. I will not return to a post after 4 days.
    If it is not important to you then it definitely is not important to me.

  3. #3
    Registered User
    Join Date
    02-19-2012
    Location
    San Antonio, Texas
    MS-Off Ver
    Excel 2013
    Posts
    69

    Re: Userform Scroll bar - can I make it autoscroll?

    No need to tidy up. I'm just poaching code here. Looks like it does exactly what I'm looking for. I'll check it out ASAP.
    Thanks so much

  4. #4
    Forum Expert
    Join Date
    12-14-2012
    Location
    London England
    MS-Off Ver
    MS 365 Office Suite.
    Posts
    8,448

    Re: Userform Scroll bar - can I make it autoscroll?

    Ok This version is much better.


    Please Login or Register  to view this content.


    The Nudge Subroutine can be improved as:-

    Please Login or Register  to view this content.
    Attached Files Attached Files
    Last edited by mehmetcik; 09-28-2017 at 05:34 PM.

+ 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. [SOLVED] How can I make an Excel spreadsheet slowly autoscroll
    By thedunna in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 08-16-2017, 08:51 AM
  2. How do I get the scroll distance of a userform listbox scroll bar...
    By Rob Frankham in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 12-31-2014, 04:23 PM
  3. make an userform able to scroll with a mouse
    By Fhorst in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-23-2014, 10:59 AM
  4. How Do I make a Userform Resizable or allow it to scroll
    By Invicta084 in forum Excel Programming / VBA / Macros
    Replies: 13
    Last Post: 01-25-2014, 06:57 AM
  5. Autoscroll Update
    By jomili in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 03-09-2011, 11:18 AM
  6. Recreate AutoScroll
    By rjamison in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-13-2005, 08:05 PM
  7. Recreate AutoScroll
    By Soli3d in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-20-2005, 12:06 PM

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