Home » Blogs » Nick's blog

5. VBA Tips - Time Your Code

Nick's picture
Submitted by Nick on 9 March, 2009 - 11:51


How do you time how long it takes for VBA code to run ?

Simple..

Step1: At the start of your code, create a variable called "Start" (or whatever)

Set it = Timer (that takes a snapshot of the time)

 

Step2: At the End of your code, you can use a messagebox to display how long it took.

MsgBox Timer - Start & " Seconds"

time-VBA-code

Download Spreadsheet to see example of how to Time VBA code

Training Video on how to time your code:

»
Almir's picture

Could you post your code here?

Submitted by Almir on 15 January, 2014 - 08:28.

Please post your code here.

»
NimaIranian's picture

convert to second

Submitted by NimaIranian on 12 January, 2014 - 06:40.

i tried your code in my macro and msgbox have shown 36258 seconds

but with a stopwatch i get 1':16" (1 min and 16 sec)!!!

but i could recolonize which one is correct.

pls advise.

»