+ Reply to Thread
Results 1 to 4 of 4

CommandButton to Change Userform ScrollBar-ScrollTop Property

  1. #1
    Registered User
    Join Date
    11-24-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    28

    CommandButton to Change Userform ScrollBar-ScrollTop Property

    Hi,

    I have a userform which is longer than the standard dimensions for using the printform command function.
    I already have a command button which can take a print screen of the userform and send it to a word document, but from experience the users of this userform will not use that function and would prefer the direct print option.

    Even though the userform is long, I only need to print a specific area of the form and was wondering if there was a way to use a command button to automatically change the scrolltop property of the form (or just move the scrollbar position to near the top), and then use the printform function after.

    The scrollbar isn't one from the toolbox but instead the builtin userform scrollbar from the properties window.

    Example userform attached.

    I appreciate any help you can give.

    Thanks,
    Attached Files Attached Files

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

    Re: CommandButton to Change Userform ScrollBar-ScrollTop Property

    THis line will move to the top.


    Please Login or Register  to view this content.
    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
    11-24-2013
    Location
    London, England
    MS-Off Ver
    Excel 2007
    Posts
    28

    Re: CommandButton to Change Userform ScrollBar-ScrollTop Property

    I should of mentioned that the scrollbar was on a multipage not the userform. However, I will just change that so that the scrollbar is on the userform and the above code will work then.

    Thanks for your help mehmetcik

  4. #4
    Registered User
    Join Date
    09-04-2019
    Location
    Cuba
    MS-Off Ver
    2019
    Posts
    1

    Re: CommandButton to Change Userform ScrollBar-ScrollTop Property

    (Sorry my english) I have the same problem, when I move the srcollbar my bottom lose the position, if you fixed please help me. Thank you

+ 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. How to change macro in commandbutton in a Userform depending on what is displayed.
    By thecdnmole in forum Excel Programming / VBA / Macros
    Replies: 10
    Last Post: 10-10-2014, 04:40 PM
  2. Change ScrollBar Max value when a second ScrollBar vale is changed?
    By Jon Henry in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-11-2013, 06:47 PM
  3. Commandbutton in userform to execute code based on a previous commandbutton choice?
    By michaeljoeyeager in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 07-20-2012, 03:28 PM
  4. Change commandbutton text from userform
    By peter.thompson in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-16-2005, 11:10 PM
  5. ScrollBar property
    By Ben in forum Excel General
    Replies: 1
    Last Post: 10-31-2005, 03:05 AM

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