Excel VBA - Create Countdown Timer on UserForm
Вставка
- Опубліковано 6 вер 2024
- How to create a countdown timer on a UserForm (with "HP" bar)?
Allow users to set the duration they need.
Step-by-step tutorial from creating and designing a timer to coding.
Multiple timers 👉 • Excel VBA - Multiple t...
Facebook public group for Excel and VBA discussion 👉 / 486402069483674
Welcome to join 🤗
I liked your video, it was very informative and useful. I am having a small problem embedding it on the correct page on my excel quiz form so that the timer shows up on each question. In addition to have it record the completion time into my excel "Answer Sheet. any help or advice wold be greatly appreciated.
Hi. If the questions are on different sheets, we can try the "SheetChange" procedure in VBA. Unload the timer when moving to the next sheet before recalling the timer. We can locate the desired cell address using "ActiveSheet.Range("CellAddress") before the timer is unloaded.
Hope this helps. Thanks for watching and have a nice day.
God Bless you!
Thanks!
Thanks for watching and have a nice day.
Do you have Countup Timer on UserForm in PowerPoint, I hope you can do it!
Hi. '-1' is for countdown. For elapse, change '-1' to '1'.
Thanks for watching and have a nice day.
Thank you so much. This help me so much with my work. My question, can we add multiple timer in one userform to run simultaneously?
My pleasure.
Regarding your question, not really possible because VB can only run one code per time. Although we can combine all codes in one command, it will result a time lag and cause the timer to run inaccurately.
Thanks for watching and have a nice day.
@@ahsingtvthanks for your reply. Actually i manage to make multiple timer display on spreadsheet and can run simultaneously. But fail to make it multiple display on userform.. Anyways thanks for your info. 🙏🙏🙏
No problem. My pleasure.
Any advice on adding a pause button to the timer? Or a save button? I want to allow my user's to time their work, but if they need to pause, I'd like to save the pause and unpause times. If they finish early, I'd like the time to be saved as they move on to the next timed activity I am trying to code.
Hi, may combine with this ua-cam.com/video/8tkF4bqtHpg/v-deo.html.
To save a time, I would suggest to print the time on a cell, and we just have to read the cell for the next run.
Thanks for watching and have a nice day.
Video excellent, but - what's a pity.... it doesn't work on my Excel 2016.. could you be so kind and make this exemplary file available to download?
Hi Tomek. I should have considered to let the file open for free download. Unfortunately, I can't recall the password that I set, thus I deleted the file. Now, I only have this facebook.com/groups/486402069483674/permalink/649814163142463
Not sure if you want it.
Thanks for watching and have a nice day.
Excellent video. Can I have more than one user form called intermittently if I need to a second or third timer to run at different times? Thank you!
Hi Jason. Is this ua-cam.com/video/oV5izV7DS0c/v-deo.html the one you are looking for?
Hope it helps. Thanks for watching and have a nice day.
@@ahsingtv
Thank your quick reply. I watched that video and it is wonderful. However, I like this timer here. I have created it and made two separate timers. Both will come up when I press the button for that timer, but they will not run at the same time. I need them to run at the same time. Can you help with that please? Thank you!
Could you send the file to my email at durian1.apple@gmail.com?
super duper🚀
Thanks!
Thanks for watching and have a nice day.
Thanks 🙏🙏
My pleasure. Thanks for watching and have a nice day 😊
on "Application.Wait" It is showing method or data variable not found. What should I do?
Hi. On Application.Wait (Now + #12:00:01 AM#), the "#12:00:01 AM#" may not applicable for your version.
May try "TimeValue("0:00:01")" instead.
Hope it helps. Thanks for watching and have a nice day.
Do you have a Visual studio 12 version of the code?
Hi. Sorry I don't have.
Thanks for watching and have a nice day.
Mr Ah sing are you from Singapore.
Hi. Nope. Because of my Singlish-style? XD
Btw, thanks for watching and have a nice day.
@@ahsingtv thank you for answering very prompt. I hope you could help me to create a six digit counter that could register generate number on excel. But the each six number not starting from 1 to 9 but could be 1 to 49. It should start from last digit then when 49 appear it should next digit and so on for rest of the digit it is possible.
@@ahsingtv thank you for answering very prompt. I hope you could help me to create a six digit counter that could register generate number on excel. But the each six number not starting from 1 to 9 but could be 1 to 49. It should start from last digit then when 49 appear it should change next digit and so on for rest of the digit it is possible.
Hi Harold.
I have few questions,
1. "register generate number" means users are allowed to input any numbers ranged from 1 to 49? Or the numbers are supposed to be generated randomly?
2. is it a timer? Meaning, the generated number should then be increased by 1 per second and reaching 49. Once reached, proceed to the next digit?
Feel free to tell me in more detailed, preferably in steps form via email at durian1.apple@gmail.com.
Have a nice day.
@@ahsingtv This more like counter than timer.It had a six counter window. You could input each window your desired number .It start from last window rotate from 1 to 49 it turn next window number and so on till to the first. But also to set desired number generate and stop. All number generated should record on excel
can you share the code
🤔 Really sorry that I couldn't copy and paste the code for you as I had set a password for that file and I tried for many many times but I couldn't recall the password 😅
AhSingCountdown
?
Looks ugly
In this world, there are those blessed with beauty and kindness, who perceive everything through a lens of beauty. Regrettably, there are also those who embody the opposite. Alas! What a pity.