asked on 4/1/2017

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

Microsoft Excel Microsoft Office

Last Comment

Bright01

4/2/2017

Roy Cox

4/1/2017

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 Cox

4/1/2017

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

Bright01

4/1/2017

ASKER

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

B.

Roy Cox

4/1/2017

Are the rest of the changes OK?

SOLUTION

Ramin

4/1/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

ASKER CERTIFIED SOLUTION

Roy Cox

4/1/2017

THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

Roy Cox

4/1/2017

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

Bright01

4/2/2017

ASKER

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.

Ramin

4/2/2017

Thanks,

Roy Cox

4/2/2017

Pleased to help.

Did the speech work?

Bright01

4/2/2017

ASKER

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.