Avatar of Bright01
Bright01
Flag for United States of America asked on

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 ExcelMicrosoft Office

Avatar of undefined
Last Comment
Bright01

8/22/2022 - Mon
Roy Cox

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

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

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

B.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23
Roy Cox

Are the rest of the changes OK?
SOLUTION
Ramin

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
ASKER CERTIFIED SOLUTION
Log in to continue reading
Log In
Sign up - Free for 7 days
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Roy Cox

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

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.
Get an unlimited membership to EE for less than $4 a week.
Unlimited question asking, solutions, articles and more.
Ramin

Thanks,
Roy Cox

Pleased to help.

Did the speech work?
Bright01

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.
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy