+ Reply to Thread
Results 1 to 6 of 6

Help creating a continuously scrolling screen update with Excel VBA

  1. #1
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Help creating a continuously scrolling screen update with Excel VBA

    Hi All:
    I’m fairly new to using User Forms with VBA (used them once). I have a VBA module that basically continually runs on a dedicated windows 10 machine with Excel 2016. What I’d like to do is hide the application and just show the status of what the module is doing such as...
    “Updating xxx file at 20:15pm”
    “Created new customer xxx at 9:15am”
    Etc.
    Etc.
    No problem with the module or creating the status text – but I don’t know how to show a continuously scrolling display of status lines (could be hundreds of lines to show before the module is stopped/restarted)
    Can this be done with User Forms? Is there a better way?
    Thanks for any guidance.

  2. #2
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Help creating a continuously scrolling screen update with Excel VBA

    Absolute simplest thing to do is put a Listbox on userform and simply add to the ListItems making sure the last item is selected so it displays...

  3. #3
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Help creating a continuously scrolling screen update with Excel VBA

    Hi,

    Not entirely sure what you mean by hide the application. If you just mean that you'll move to another non Excel window leaving Excel to run in the background yhen the simplest option would be to use the Status Bar, and add a line of code like

    Please Login or Register  to view this content.
    at various places in your macro code
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  4. #4
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Help creating a continuously scrolling screen update with Excel VBA

    While I would agree with Richard, you also mention the code "runs on a dedicated windows 10 machine" so am assuming it is not being used interactively. If so, there's no issue hiding the application and it would make things a lot neater without Excel cluttering up the background... Sample with a listbox attached. This hides the application and adds random strings (Actually Excel Error messages so ignore anything you might think a little strange with the messages) at random intervals of between 1 and 5 seconds.
    Attached Files Attached Files

  5. #5
    Forum Contributor
    Join Date
    03-15-2016
    Location
    Vancouver, Canada
    MS-Off Ver
    w 10, Excel 2016
    Posts
    125

    Re: Help creating a continuously scrolling screen update with Excel VBA

    cytop. This is exactly what I was looking for. I can't say I understand all of the Form code - but I'm sure I can adapt it.
    Brilliant and thanks so much.

  6. #6
    Forum Expert
    Join Date
    02-14-2009
    Location
    .
    MS-Off Ver
    ................
    Posts
    2,840

    Re: Help creating a continuously scrolling screen update with Excel VBA

    You don't need most of the code - it's only there to populate the listbox for the demo - anything referring to the timer can be removed as can the procedure to generate the error message...

+ 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. Continuously scrolling progress bar while macro runs "Connecting to server"
    By DJDRU in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2016, 11:12 PM
  2. Controlled vba screen scrolling
    By buckhunt122 in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-06-2011, 01:56 AM
  3. [SOLVED] How do I keep a text box on the screen when scrolling in excel?
    By Paulm in forum Excel General
    Replies: 4
    Last Post: 07-27-2006, 10:40 AM
  4. [SOLVED] How do I keep a text box on the screen when scrolling?
    By Paulm in forum Excel General
    Replies: 1
    Last Post: 07-27-2006, 08:40 AM
  5. How do you continuously update time and date in an Excel cell?
    By engine99 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-20-2005, 11:06 PM
  6. [SOLVED] How do you continuously update time and date in an Excel cell?
    By engine99 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-20-2005, 05:06 PM
  7. [SOLVED] How to continuously update time in Excel?
    By Ray_Fry in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-20-2005, 03: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