Counting Timer - Up and Down

After great work by 4 EE Pros, Brad Yandt, Professor Jim Jam, Ramin and Roy Cox, I got a great little Countdown Timer that I can use.  As generally the case, the  more I worked with this Team of professionals, the more I realized I could make this even better and albeit simpler.

So here is the ask.  I'm attaching the work that has been done on the Countdown Timer + a Form that I have produced to demonstrate what this should look like.  I thought I'd use a form so you can call it up, set the timer and then hide it easily.  The original countdown timer works by using the two Worksheets.  The one I'm asking for uses the Form only.  What is different also is that it should count down if a number is entered into the Excel cell (in the form) that is formatted for time.  If the number is not 0:00:00, then when you press the Count! button it should count up (no set ending).  If a number is entered, say 1:30:00 it would then realize it's a count down and when you click on Count, it counts down and then announces  when the time is up (Roy put this in the original code -- way cool!).  

That's it!   Hope you engage with this one.  It's a little bit more complicated but I'm looking forward to learning how to do this by watching you pros.

Thank you in  advance,


B.
Countdown-Timerv6.3.xlsb
Bright01Asked:
Who is Participating?
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.

David Johnson, CD, MVPOwnerCommented:
computers aren't that smart. if cell is blank or zero count up, if valid value count down..
0
Bright01Author Commented:
What?   If you "fire" the Count! Macro, it can't check  to see if Cell<> or = to -0-, so begin count, otherwise, take the number and count down?

B.
0
David Johnson, CD, MVPOwnerCommented:
The original way that I read it was, if there is a value it was ambiguous whether or not to count up or count down. It appears I was mistaken
0
Determine the Perfect Price for Your IT Services

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

Roy CoxGroup Finance ManagerCommented:
You haven't used any code in the form from what I can see, I'll take a look later.
0
Bright01Author Commented:
Roy,  I'm not skilled at moving code from Modules and Worksheets into Forms.  I think the code you guys put together before did the job so most of it can be transferred into the form.  EXCEPT for the streamline of determining count up  or count down.

Thank you,

B.
0
Roy CoxGroup Finance ManagerCommented:
I created a UserForm with a Timer on a few years ago. I'll try to find it and adapt it.
0
Roy CoxGroup Finance ManagerCommented:
This example has a Start, Stop & Pause Button. Check it out and let me know if it is on the right track. If it is I need to figure out the count down part.

I'll try to take a look tomorrow.
0
Bright01Author Commented:
Roy,

Thanks for the effort.  Did you mean to attach something?

B.
0
Roy CoxGroup Finance ManagerCommented:
Sorry, I was late home and in a rush. Must have not clicked the attach button.
0
Bright01Author Commented:
Ha!  Roy, still no attachment!  Get some rest.

B.
0
Roy CoxGroup Finance ManagerCommented:
Don't know why it's not attaching
EE_Timer-v1.02.xlsm
0
Bright01Author Commented:
Roy,  Welcome back!  Almost there!  Very well done so far;

Two items;

There needs to be a reset capability to clear the Countdown/Countup cells.  And 2, I can't get the countdown to work.  If I put in 01:00:00 as in 1 hour, and hit start, it starts to count up when it should recognize that there is an entry in the countdown cell and begin counting down instead.

Thank you very much for your work.  I can tell you work hard at what you do and concurrently enjoy helping others.  Thanks again.

B.
0
Roy CoxGroup Finance ManagerCommented:
I haven't put in a count down yet.

I am confused though about your reference to a cell, do you mean the TextBox on the UserForm?
0
Bright01Author Commented:
Sorry I was not clear.  What I'm thinking is that the countdown and countup box are the same box.  If the number in the box is -0- or blank, then it counts up.  However, if there is a number such as 01:00:00, then it automatically knows that it is a countdown situation.

Make sense?

B.
0
Roy CoxGroup Finance ManagerCommented:
If that is the case then the pause button won't work. The time is currently in a Label which prevents entry. I thought to add a TextBox to enter a time in.
0
Bright01Author Commented:
Let's go with your approach to keep it simple.

Thanks,

B
0
ProfessorJimJamCommented:
Bright01,

i am not sure what are you trying to achieve with this Countdown timer, but there is a very good free Add-in Developed by Tushar Mehta you can have a look and see how it works, maybe that would help.

http://www.tushar-mehta.com/excel/software/vba_timer/
0
Bright01Author Commented:
Professor Jim,

Did you see Roy's posted WB/WS?

The timer counts Up and counts Down.  I'll take a look at Tushar's work too.

B.
0
Roy CoxGroup Finance ManagerCommented:
I'll get back to this, I need to get the count down working as required.
0
Bright01Author Commented:
Are we still working on this or should I close it out?
0
Roy CoxGroup Finance ManagerCommented:
Sorry, I'm working on it but I've not been too well this last week.
0
Bright01Author Commented:
No worries.  Just checking.
0
Roy CoxGroup Finance ManagerCommented:
I've managed to get the count down working as I wanted.

I've added a quick entry for times.

I just need to tidy up the userform and I'll upload a completed file.
0
Roy CoxGroup Finance ManagerCommented:
Sorry about the delay.

This form contains the counter that was in the previous example plus a count down. To make ure that the time is entered in the correct format the code amends the display so entering 000010 will be changed to 00:00:10, i.e. 10 seconds.
EE_Timer-v1.05.xlsm
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
Bright01Author Commented:
Roy, Thank you so much for sticking with this endeavor.  Well done!  I'll be working on it until I break it which is when I'll author a follow on question.  Again, great job!  You have a lot of tenacity to stick with things until completed.

Best regards,

B.
0
Roy CoxGroup Finance ManagerCommented:
No problem B. Let me know what you need to do further
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.