Countdown timer help

[Styler001]

Hello, all.

I've got a co-worker who's retiring at the end of the month, and I wanted to put this on a spare laptop that's just sitting around so everyone can see the countdown.

I found this VBA script for a countdown timer on YouTube:

https://www.youtube.com/watch?v=sbJeGG_Xv8M

I can get it to work with the basic examples the guy gives, but I need it to count down from 273 hours. When I put that in the cell A12 as 273:00:00 with the cell formatted as hh:mm:ss, when I press Enter it changes the text in the cell to "9:00:00 AM" and displays in the formula bar as "1/11/1900 9:00:00 AM". If I format it as [h]:mm:ss, when I press enter it stays as 273:00:00, but when I start the timer, it again displays in the formula bar as "1/11/1900 9:00:00 AM".

Here's the code for the two command button's:

Please Login or Register  to view this content.

And here's the module code so no one has to replay the video over and over like I had to:

Please Login or Register  to view this content.

I'm really useless when it comes to VBA scripts, so if anyone can help figure this out, I'd really appreciate it.

Thanks in advance. You all are the best.

[Styler001]

I actually got this to work. Probably not the "proper way", but it's working nonetheless.

After the countdown started, I just formatted the A12 cell to [h]" hrs", mm" min", ss" sec". Counting down as hoped for.

If there's a better way, I'd love to hear it, so I won't mark this as solved just yet.