Hello,
I want to create a small app in Excel to count down a time and count up after the time passed. The logic is very straigth forward.
1. I use Now() function to get the present time from Windows and plus 10 minute.
2. I use Hour(), Minutes() and second () to get value of Hour, Minute and Second.
3. I use time from 1 minus 2 to show the remaining time.
The problem is I have to press F9 to re-calculate / refresh the page every second in order to make the time count down. I think I can use Excel VBA to make it refresh every second. However, I do not know the VBA. Please give me a comment.
Thank you in advance.
I want to create a small app in Excel to count down a time and count up after the time passed. The logic is very straigth forward.
1. I use Now() function to get the present time from Windows and plus 10 minute.
2. I use Hour(), Minutes() and second () to get value of Hour, Minute and Second.
3. I use time from 1 minus 2 to show the remaining time.
The problem is I have to press F9 to re-calculate / refresh the page every second in order to make the time count down. I think I can use Excel VBA to make it refresh every second. However, I do not know the VBA. Please give me a comment.
Thank you in advance.
