+ Reply to Thread
Results 1 to 4 of 4

Create timer to check running time for "Master" macro

Hybrid View

  1. #1
    Registered User
    Join Date
    03-04-2017
    Location
    norway
    MS-Off Ver
    2016
    Posts
    41

    Create timer to check running time for "Master" macro

    Hell0! I hope anyone can help me with the following problem:
    How do I create a timer in a master macro? I got total 21 macros in one Master and I want to check the duration time for the whole master to finish.

    I appreciate any help.

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

    Re: Create timer to check running time for "Master" macro

    
    Sub x()
    
       Dim t As Single
       Dim x As Long
       
       t = Timer
       
       Do While x < 100000
          DoEvents
          x = x + 1
       Loop
       
       MsgBox "Time elapsed: " & Timer - t & " seconds"
       
    End Sub

  3. #3
    Registered User
    Join Date
    03-04-2017
    Location
    norway
    MS-Off Ver
    2016
    Posts
    41

    Re: Create timer to check running time for "Master" macro

    Thank you so much! I tried to create the macro, then set in first in my "Master" macro, but got an error; "timer needs to be a function".

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

    Re: Create timer to check running time for "Master" macro

    The sample code I posted works - so any issues are on your side. However, without seeing your code it's a pure guessing game...

+ 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. Create a running total - create a "pretty" report
    By excelnewbie1234567 in forum Excel General
    Replies: 1
    Last Post: 03-08-2017, 11:41 AM
  2. Replies: 1
    Last Post: 08-15-2014, 06:00 AM
  3. Macro for "Master" and "Child" products with image files
    By ddenicola in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-20-2014, 08:30 AM
  4. Replies: 5
    Last Post: 01-23-2014, 11:02 AM
  5. Countdown Timer in Excel with a "pause" and "start" button
    By bbhagwat in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 09-13-2013, 05:49 AM
  6. Replies: 0
    Last Post: 06-24-2013, 04:24 PM
  7. [SOLVED] create links to check boxes marked "good" fair"and "bad"
    By pjb in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 04-19-2006, 09:25 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