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

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

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 KZread 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!

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

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

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

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.

great video man

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.

good project...

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?

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

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

10 жыл бұрын

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

Thank you for this!

@ExcelVbaIsFun

3 жыл бұрын

You're so welcome!

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

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

what is the coding for stop command

That's it

waardeloos dit

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

What is nr

me sale error 404

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