Countdown Timer Enhancement 1

Bright01
Bright01 used Ask the Experts™
on
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
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Roy CoxGroup Finance Manager

Commented:
Reset the Timer with

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

Open in new window


I'll take at the other step now
Roy CoxGroup Finance Manager

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

Author

Commented:
Roy,  yes.  A beep at the end would be great!

B.
Ensure you’re charging the right price for your IT

Do you wonder if your IT business is truly profitable or if you should raise your prices? Learn how to calculate your overhead burden using our free interactive tool and use it to determine the right price for your IT services. Start calculating Now!

Roy CoxGroup Finance Manager

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

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

Author

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.
RaminTechnical Advisor

Commented:
Thanks,
Roy CoxGroup Finance Manager

Commented:
Pleased to help.

Did the speech work?

Author

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.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial