Excel VBA Tips n Tricks #18 Stopwatch in Excel

Here's a stopwatch you can make with very few lines of code in Excel.

Fantastic Developer Tools:

[TomSaladin]

Hi Dan, Thank you for this channel. I have been following Bill, MrExcel, Mike ExcelisFun & many others for many years. Now, finally the channel I have been waiting 4. I have checked out many VBA videos on YouTube channels & they're OK for specific things but your's shows things In the way the same "teaching way" that Mike and Bill do so well. I look forward to watching every video after watching a few dozen so far. Thank You again & keep up the great work!

[kcedrickd]

Hi, Dan! This is very helpful. However, the timer stops when going to a different application (e.g. word, internet explorer). Is there any code that will allow the timer to run even if this excel workbook is minimized (not closed)? Thanks! I hope for your response as regards this matter.

[TheTank]

Thanks Dan! The only specific question about VBA I can even think of right now is about "syntax". I worked with a great SQL guy who knew syntax in a way I never I could understand but I now think you can explain it in a way he could not. He was from Brazil so he did have a disadvantage :)

[donaldgoff]

You removed the stop button. I would think setting the Stop button to put "Now" in column "B" and give the difference between the two in column "C" would complete this. Good work. Thanks for your help.

[krn]

Thanks Dan. I have used a timer before, but only 3 seconds at a time.

[ExcelVbaIsFun]

Merry Christmas everyone. I hope God blesses you richly this upcoming year. Remember, you ARE a success!! Believe it, be it! Blessings my friends!! Dan

[ExcelVbaIsFun]

Hmm. . . Good idea, I was wondering what to do with that, but went blank. Lemme try to implement this in a new video. Thanks for your kind words. Dan

[nilsanity]

i have a question: is there a way that the macro I have would run on a specific time? lets say I would like them to run every 00:00 and 00:30?

[ExcelVbaIsFun]

Wow! Thanks Tom. I'm putting aside some time this weekend to make some more. Lemme know if you have any questions/topics. Dan

[joshualong]

Is there a way that I can get the timer to count to the tenths or hundredths of a second?

[karazadakis]

This tutorial worked great for what I was trying to do! My only question is, if I wanted to have a timer from B2 to B6 and then B8 to B12, how would I do that? Or what if I wanted to have the timer above a cell of text. Can you specify which cells the timer works in rather than just where it starts?

[ricardobatista]

Thank you, Dan. Suggestion: the first 2:23 minutes are redundant (i.e., I believe viewers would appreciate it if you got rid of it).

[AnirbanSahaanirban]

Hello... Can u tell me that what will be stop time vba code instead of Reset

[jhonsalasvidal]

Solucion 
Sub StartTimer()
    nr = ThisWorkbook.Sheets("Hoja1").Cells(Rows.Count, 1).End(xlUp).Row + 1
    Cells(nr, 1) = Time
End Sub

[randulakarunajeewa]

I have tried this but I keep getting a Error 400 and the time is not displayed when I use the start button.