+ Reply to Thread
Results 1 to 5 of 5

status update to show running subroutines

  1. #1
    Forum Contributor
    Join Date
    03-31-2017
    Location
    usa
    MS-Off Ver
    2013
    Posts
    104

    status update to show running subroutines

    hi, is there some code I can use that will show on the screen which sub is currently running as the program goes through the various subs?

  2. #2
    Forum Expert sintek's Avatar
    Join Date
    12-04-2015
    Location
    Cape Town
    MS-Off Ver
    2013 | 2016 | 2019
    Posts
    13,239

    Re: status update to show running subroutines

    http://www.ozgrid.com/forum/showthread.php?t=17890
    Good Luck
    I don't presume to know what I am doing, however, just like you, I too started somewhere...
    One-day, One-problem at a time!!!
    If you feel I have helped, please click on the star to left of post [Add Reputation]
    Also....add a comment if you like!!!!
    And remember...Mark Thread as Solved.
    Excel Forum Rocks!!!

  3. #3
    Forum Contributor
    Join Date
    03-31-2017
    Location
    usa
    MS-Off Ver
    2013
    Posts
    104

    Re: status update to show running subroutines

    is there another site that has this code? this site is blocked by security at work?

  4. #4
    Forum Guru Norie's Avatar
    Join Date
    02-02-2005
    Location
    Stirling, Scotland
    MS-Off Ver
    Microsoft Office 365
    Posts
    19,643

    Re: status update to show running subroutines

    The code on that site would only really be helpful if you were running the code from a button, and even then would only return the button name.

    What you could look at is using Application.StatusBar at the start and end of each of your subs.
    If posting code please use code tags, see here.

  5. #5
    Forum Contributor
    Join Date
    03-31-2017
    Location
    usa
    MS-Off Ver
    2013
    Posts
    104

    Re: status update to show running subroutines

    thx. that does work.

+ 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. auto update weekly table basis status update
    By JJJ_1812 in forum Excel General
    Replies: 3
    Last Post: 04-28-2016, 03:38 AM
  2. Status update while query running
    By Urby1Kinobe in forum Access Programming / VBA / Macros
    Replies: 1
    Last Post: 06-19-2015, 09:17 AM
  3. [SOLVED] Running subroutines
    By tjgrassi in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 06-27-2014, 11:54 AM
  4. arrange data to show different billing status and customer status
    By applesandpears in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 11-29-2012, 05:57 PM
  5. [SOLVED] can't debug some subroutines in my project, locked subroutines
    By florin_excel in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-28-2012, 01:16 PM
  6. running subroutines concurrently
    By thomas 1950 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-12-2007, 06:25 PM
  7. [SOLVED] How to display a form- to show status of the running program
    By Joseph in forum Excel General
    Replies: 2
    Last Post: 05-31-2005, 07: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