After great work by 4 EE Pros, Brad Yandt, Professor Jim Jam, Ramin and Roy Cox, I got a great little Countdown Timer that I can use. As generally the case, the more I worked with this Team of professionals, the more I realized I could make this even better and albeit simpler.
So here is the ask. I'm attaching the work that has been done on the Countdown Timer + a Form that I have produced to demonstrate what this should look like. I thought I'd use a form so you can call it up, set the timer and then hide it easily. The original countdown timer works by using the two Worksheets. The one I'm asking for uses the Form only. What is different also is that it should count down if a number is entered into the Excel cell (in the form) that is formatted for time. If the number is not 0:00:00, then when you press the Count! button it should count up (no set ending). If a number is entered, say 1:30:00 it would then realize it's a count down and when you click on Count, it counts down and then announces when the time is up (Roy put this in the original code -- way cool!).
That's it! Hope you engage with this one. It's a little bit more complicated but I'm looking forward to learning how to do this by watching you pros.
Thank you in advance,