+ Reply to Thread
Results 1 to 3 of 3

How to move scroll bar to the top using VBA?

  1. #1
    Registered User
    Join Date
    12-01-2020
    Location
    London
    MS-Off Ver
    2013
    Posts
    22

    Question How to move scroll bar to the top using VBA?

    I have a list of date and a scroll bar is linked to it. I need to add a button that when I click it, the scroll bar goes to the top. How should I do it? The sample file is attached.
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS 365 Family 64-bit 2502
    Posts
    26,995

    Re: How to move scroll bar to the top using VBA?

    Solution attached. The file must be converted to xlsm. I added a button and the code for the button sets the value of J12 to 1. The cell is linked to the scroll bar so this will also cause the scroll bar to scroll to the top position.
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    12-01-2020
    Location
    London
    MS-Off Ver
    2013
    Posts
    22

    Re: How to move scroll bar to the top using VBA?

    wow! You did an excellent job! Thank you so much!
    Last edited by AliGW; 01-31-2021 at 11:12 AM. Reason: PLEASE don't quote unnecessarily!

+ 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. Need to move cell content with scroll
    By msub in forum Excel General
    Replies: 0
    Last Post: 01-12-2012, 07:09 PM
  2. Replies: 1
    Last Post: 08-09-2006, 02:34 PM
  3. [SOLVED] Is it possble that a chart move while you scroll
    By luvgreen in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 06-06-2006, 11:00 AM
  4. I can not move or scroll to the top rows (7 to 1)
    By sax30 in forum Excel General
    Replies: 1
    Last Post: 09-11-2005, 09:05 AM
  5. [SOLVED] I can not move or scroll to the top rows (7 to 1)
    By sax30 in forum Excel General
    Replies: 1
    Last Post: 08-11-2005, 03:05 PM
  6. [SOLVED] When I move scroll bar in excell the contents do not move with it
    By ramneek in forum Excel General
    Replies: 2
    Last Post: 06-29-2005, 03:05 PM
  7. how to have my titles move down as i scroll down the page
    By DAVIDPEOVER in forum Excel General
    Replies: 1
    Last Post: 05-26-2005, 05:15 PM
  8. [SOLVED] Auto move scroll bars of listbox
    By JON JON in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-03-2005, 11: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