Hi
I have a workbook in excel that rotates a circle when a button is clicked. I would like a timer in seconds to start also when the button has been clicked and to be displayed in cell A1. What would be the best way to do this?
Thanks
Hi
I have a workbook in excel that rotates a circle when a button is clicked. I would like a timer in seconds to start also when the button has been clicked and to be displayed in cell A1. What would be the best way to do this?
Thanks
probably best idea would be to use
in sub UpdateCell() not only display but againPlease Login or Register to view this content.
here_time as public variable, to make sure you can kill the process obce you want to stop.Please Login or Register to view this content.
Best Regards,
Kaper
Hello
Put this code in a Module in VBA (Developer Tab -> Visual Basic)
You can invoke the "StartTimer" function when the workbook opens and have it repeat every second by adding the below code to your workbooks Visual Basic "This.Workbook" class in the Visual Basic editor.Please Login or Register to view this content.
Now, every time 1 second passes the Timer procedure will be invoked, and set cell A1 equal to the current time.Please Login or Register to view this content.
Regards
Fotis.
-This is my Greek whisper to Europe.
--Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.
Advanced Excel Techniques: http://excelxor.com/
--KISS(Keep it simple Stupid)
--Bring them back.
---See about Acropolis of Athens.
--Visit Greece.
Cheers! this code works well, I should be able to modify it to get it to do what I need! Thanks a million for the help!
You are welcome and thanks for the feedback.
As that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED,as per Forum Rule #9. Thank you.
Also, as a new member of the forum, you may not be aware that you can thank those who have helped you by clicking the small star icon located in the lower left corner of the post in which the help was given. By doing so you can add to the reputation(s) of those who helped.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks