Countdown Timer Enhancement 1

EE Pros,

I have a simple countdown timer that Professor JimJam and Brad Yundt wrote for me that I have attached.   I'm trying to simply do two things with it.  1.) provide a simpler input capability for users by simplifying the first tab (details on first tab) and 2.) also include a reset button to take the timer back to -0- or start in the event that you want to set a new time.

This is one of three asks for this timer but I have broken it down into steps.  

Thank you in advance,

B.
Countdown-Timerv6.xlsb
Bright01Asked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

Roy CoxGroup Finance ManagerCommented:
Reset the Timer with

Sub ResetTimer()
Range("A2").Value = 0
End Sub

Open in new window


I'll take at the other step now
1
Roy CoxGroup Finance ManagerCommented:
I think this simplifies the Input. I've grouped the top rows so that you can hide and unhide as required and added a formula to create the time in C2

Did you also want it to Beep at some point?
Countdown-Timerv6.xlsb
0
Bright01Author Commented:
Roy,  yes.  A beep at the end would be great!

B.
0
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

Roy CoxGroup Finance ManagerCommented:
Are the rest of the changes OK?
0
RaminTechnical AdvisorCommented:
With reset Button.
Countdown-Timerv6.xlsm
0
Roy CoxGroup Finance ManagerCommented:
Not sure if this is what you want, but try this
Countdown-Timerv6.xlsb
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Roy CoxGroup Finance ManagerCommented:
ramin

It's not necessary to select

 
Range("A2:B2").Select
    ActiveCell.FormulaR1C1 = "12:00:00 AM"

Open in new window


This should simply be

 Range("A2:B2").FormulaR1C1 = "12:00:00 AM"

Open in new window

1
Bright01Author Commented:
Roy and Ramin, thank you!  After going through this exercise with you, I now better understand what I want and what I need.  I'm posting another question and hope you guys will pick up the challenge.  Much thanks again.

b.
0
RaminTechnical AdvisorCommented:
Thanks,
0
Roy CoxGroup Finance ManagerCommented:
Pleased to help.

Did the speech work?
1
Bright01Author Commented:
The Speech was awesome!  I never knew you could do that.  And I changed it to listen to it talk back to me.  Kinda like having your wife tell you what to do next ;-)

Hope you will pick  up the next "turn of the crank".  I've redesigned it to be simpler, count up or down  and still use voice on a count down.  All in a form so it can come up during other activities, you can set the count and then have it run in the background.  I think a lot of it is taking the code you and others provided and putting it into a form instead of two tabs.

Thanks again for all the help.  I learn  something new every day from  EE.

B.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft Excel

From novice to tech pro — start learning today.