Excel VBA Tips n Tricks #18 Stopwatch in Excel

[@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 KZbin 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!

[@TheTank997]

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 :)

[@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

[@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

[@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.

[@krn14242]

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

[@karazadakis6164]

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?

[@ExcelVbaIsFun]

the b2 through b6 and skipping b7 thing could be done with this code so that it skips row 8 and ends at row 12 if nr=7 then nr=8 elseif nr=13 then exit sub end if cells(nr,1)=Time

[@donaldgoff6633]

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.

[@vinaymadhukar]

Thank you for this!

[@ExcelVbaIsFun]

You're so welcome!

[@tristanmartel503]

great video man

[@joshualong6732]

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

[@AnirbanSahaanirban]

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

[@dedesudjadi4341]

good project...

[@nilsanity2630]

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?

[@jhonsalasvidal5451]

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

[@jayakumarsj1702]

what is the coding for stop command

[@RaajKanchan]

That's it

[@randulakarunajeewa1806]

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

[@ricardobatista3807]

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).

[@garagebandnorteno4749]

What is nr

[@JohnvL]

waardeloos dit

[@jhonsalasvidal5451]

me sale error 404