+ Reply to Thread
Results 1 to 9 of 9

Automated scrolling for spreadsheet via VBA

  1. 04-23-2015, 07:19 AM #1
    erikw48 is offline
    Registered User
    Join Date
    12-15-2014
    Location
    America
    MS-Off Ver
    Microsoft Office 2013
    Posts
    20

    Automated scrolling for spreadsheet via VBA

    Hello,

    I am trying to see if there is a macro that would cause a spreadsheet to begin scrolling to a predetermined cell and do so when a hot key is pressed. Also, I would like for the macro to "loop" once the scrolling has reached the cell and begin back at the top doing this indefinitely until I or the user stops the macro. Is something like this possible?

    Thanks!
    Reply With QuoteRegister To Reply
  2. 04-23-2015, 07:32 AM #2
    LokeshKumar is offline
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Automated scrolling for spreadsheet via VBA

    Hi,

    I am not sure what is the exact requirement but this code will work...
    You can press Ctrl+break to stop the macro.....
    Here is attachment....Book1.xlsm

    Please Login or Register  to view this content.
    Lokesh Kumar
    Stay Hungry.. Stay Foolish..
    _________________________________________________________
    Please Click STAR to Add Reputation if my/someone's answer helped!
    Reply With QuoteRegister To Reply
  3. 04-23-2015, 07:38 AM #3
    erikw48 is offline
    Registered User
    Join Date
    12-15-2014
    Location
    America
    MS-Off Ver
    Microsoft Office 2013
    Posts
    20

    Re: Automated scrolling for spreadsheet via VBA

    Thank you for your insight Lokesh Kumar, the scrolling function works great! Is there anyway to edit the speed of the scroll and then a way to make it scroll "loop" and return to the top of the spreadsheet?

    Thanks!
    Reply With QuoteRegister To Reply
  4. 04-23-2015, 08:04 AM #4
    LokeshKumar is offline
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Automated scrolling for spreadsheet via VBA

    you can tweak the code like this.....
    Please Login or Register  to view this content.
    If your question is resolved, mark it SOLVED using the thread tools. Click on the star if you think some-1 helped you.
    Reply With QuoteRegister To Reply
  5. 04-23-2015, 08:07 AM #5
    erikw48 is offline
    Registered User
    Join Date
    12-15-2014
    Location
    America
    MS-Off Ver
    Microsoft Office 2013
    Posts
    20

    Re: Automated scrolling for spreadsheet via VBA

    Ahh I see, thank you very much. Is there any solution for the continuous looping effect that you may know of?
    Reply With QuoteRegister To Reply
  6. 04-23-2015, 08:15 AM #6
    LokeshKumar is offline
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Automated scrolling for spreadsheet via VBA

    Quote Originally Posted by erikw48 View Post
    Ahh I see, thank you very much. Is there any solution for the continuous looping effect that you may know of?
    See practically it is not a good idea to use loop. Even in programming it is based on problem to what kind of loop is required.
    Apart from loop, any kind of code (lengthy) will run for a short while.
    Most important during the loop you see your task messenger and check the CPU usage. You will be shocked it will be constantly used by windows.
    Reply With QuoteRegister To Reply
  7. 04-23-2015, 08:36 AM #7
    erikw48 is offline
    Registered User
    Join Date
    12-15-2014
    Location
    America
    MS-Off Ver
    Microsoft Office 2013
    Posts
    20

    Re: Automated scrolling for spreadsheet via VBA

    Well this spreadsheet will be used for a display and won't be edited during the loop so preferably I would I like to have the loop going non stop until I or someone else stops the macro. Is that an add-in that could be added to implement this sort of feature?

    Thanks!
    Reply With QuoteRegister To Reply
  8. 04-23-2015, 08:53 AM #8
    LokeshKumar is offline
    Forum Contributor LokeshKumar's Avatar
    Join Date
    03-31-2015
    Location
    India
    MS-Off Ver
    All, mostly 2010 now..
    Posts
    471

    Re: Automated scrolling for spreadsheet via VBA

    Yup you can convert it too add ins.....
    try to google ASAP Utilities for Excel....
    Reply With QuoteRegister To Reply
  9. 04-23-2015, 08:55 AM #9
    erikw48 is offline
    Registered User
    Join Date
    12-15-2014
    Location
    America
    MS-Off Ver
    Microsoft Office 2013
    Posts
    20

    Re: Automated scrolling for spreadsheet via VBA

    Okay thank you for your help LokeshKumar!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Scrolling within a spreadsheet
    By Airsoul in forum Excel General
    Replies: 3
    Last Post: 12-05-2012, 07:03 AM
  2. Automated spreadsheet
    By ZRPhelps in forum Excel - New Users/Basics
    Replies: 5
    Last Post: 09-08-2011, 05:38 AM
  3. automated spreadsheet
    By cooksey2000 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-05-2010, 07:36 PM
  4. [SOLVED] Excel Spreadsheet 10.0 - Scrolling Down - HELP
    By Knichols in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-05-2006, 12:10 PM
  5. [SOLVED] automated spreadsheet
    By neil in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 04-06-2005, 07: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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1