How to insert a COUNTDOWN TIMER in Excel

[@TimYoung-p2i]

Many thanks for sharing this. It works perfectly for my Blockbusters Gold Run Quiz!

[@MyExcelLife]

Thank you for your comment. I'm happy that it is usefyl

[@matthewdunzello7568]

Thank you for the great video, greatly appreciated! I do have a question: The timer stops running when I switch to another Excel file, is there a way to keep it running while I work in another Excel file?

[@MyExcelLife]

Good question. The countdown timer is working based on the code, so when you open the new file and start to work there - the previous one will be stopped. The solution I see here is that you move your countdown timer to the excel workbook you would like to open. You can choose the option of Making Your Macros Available in All Workbooks in Excel. You can find a video tutorial here kzbin.info/www/bejne/ooiogmyvfNV-n68

[@HarisKhan-ru4jm]

if i want to add in other sheet this timer can i copy and simply paste or do i have to do all this again

[@MyExcelLife]

Hi, you can copy paste. Keep in mind that the code is working in one active sheet

[@jetskirepublic]

How can I add another countdown timer to this worksheet without creating a conflict with the original macro module?

[@MyExcelLife]

Hi, you can add another sub. Or create a call where you can merge both subs

[@jamesflannery968]

Not sure what I am doing wrong but my stop_timer macro continues to error...I get "Run-time error '1004': Method 'OnTime' of object '_Application' failed"

[@MyExcelLife]

Thank you for your question. Sometimes we need to close this workbook and write your code from scratch

[@7DiceGaming]

how do you make 30 timers using this same setup i can't figure it out. well i think i see how now... had to make a Module for timer.. still not working right.

[@MyExcelLife]

Hi, you can use the For and Next. For example: "For Each WS In ActiveWorkbook.Worksheets" where the WS is DIM WS AS Worksheet.

[@inhgiahuy2926]

em muốn thêm âm thanh báo hết giờ. mà âm thanh này nó báo lập đi lập lại cho đến khi mình bấm nút OK trên bảng thông báo hết giờ đó thì mới hết kêu . thì em phải làm sao. em cảm ơn chị

[@MyExcelLife]

If I got correct your question (sorry, it is not in English) - you want to add a timer alarm sound. But this sound repeats over and over again until you press the OK button on the timer notification bar to stop making the sound. Your question is that you want to add the sound and stop it?

[@inhgiahuy2926]

yes. that right. thanks you@@MyExcelLife