We help IT Professionals succeed at work.

Countdown Timer Enhancement 1

122 Views
Last Modified: 2017-04-02
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

Roy CoxGroup Finance Manager
CERTIFIED EXPERT

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
CERTIFIED EXPERT

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.
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

Commented:
Are the rest of the changes OK?
RaminTechnical Advisor
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Group Finance Manager
CERTIFIED EXPERT
Commented:
This problem has been solved!
(Unlock this solution with a 7-day Free Trial)
UNLOCK SOLUTION
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

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
CERTIFIED EXPERT

Commented:
Thanks,
Roy CoxGroup Finance Manager
CERTIFIED EXPERT

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.