Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I insert a timer in an excel worksheet?
I have crated a worksheet for some mental sums. I would like to insert a
timer function, say to complete 10 sums in 1 minute. How Can I do this? Can someone help? Thanks |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I insert a timer in an excel worksheet?
Another case of showing you being easier than telling you. Hope you can
understand VBA code at least a little. Download this workbook and examine the code in the code module. Obviously the workbook contains macros, so its functionality will be determined by your Macro Security settings. Any questions you have, I'll try to answer. It's kind of a fully functional thing, I just hope you can adapt it to whatever work you've already done. http://www.jlathamsite.com/uploads/for_Khaarthic.xls I guess the important things to tell you about the code is that the Timer returns time in seconds since midnight, so you use a value like 60 for 60 seconds to be added to the time the test starts for a check. You'll see a loop containing a DoEvents statement - the program actually loops in there for the time allowed until the time is up or they click the [STOP] button I've provided. The DoEvents lets the system take care of other business like them entering their answers on the worksheet while the timer is keeping track of the time used. "Khaarthic" wrote: I have crated a worksheet for some mental sums. I would like to insert a timer function, say to complete 10 sums in 1 minute. How Can I do this? Can someone help? Thanks |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I insert a timer in an excel worksheet?
Thank you very much for your help. Your effort in creating the sample is
greatly appreciated. "JLatham" wrote: Another case of showing you being easier than telling you. Hope you can understand VBA code at least a little. Download this workbook and examine the code in the code module. Obviously the workbook contains macros, so its functionality will be determined by your Macro Security settings. Any questions you have, I'll try to answer. It's kind of a fully functional thing, I just hope you can adapt it to whatever work you've already done. http://www.jlathamsite.com/uploads/for_Khaarthic.xls I guess the important things to tell you about the code is that the Timer returns time in seconds since midnight, so you use a value like 60 for 60 seconds to be added to the time the test starts for a check. You'll see a loop containing a DoEvents statement - the program actually loops in there for the time allowed until the time is up or they click the [STOP] button I've provided. The DoEvents lets the system take care of other business like them entering their answers on the worksheet while the timer is keeping track of the time used. "Khaarthic" wrote: I have crated a worksheet for some mental sums. I would like to insert a timer function, say to complete 10 sums in 1 minute. How Can I do this? Can someone help? Thanks |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I insert a timer in an excel worksheet?
:*(** You took the link down? Do you still happen to have that file?
"Khaarthic" wrote: Thank you very much for your help. Your effort in creating the sample is greatly appreciated. "JLatham" wrote: Another case of showing you being easier than telling you. Hope you can understand VBA code at least a little. Download this workbook and examine the code in the code module. Obviously the workbook contains macros, so its functionality will be determined by your Macro Security settings. Any questions you have, I'll try to answer. It's kind of a fully functional thing, I just hope you can adapt it to whatever work you've already done. http://www.jlathamsite.com/uploads/for_Khaarthic.xls I guess the important things to tell you about the code is that the Timer returns time in seconds since midnight, so you use a value like 60 for 60 seconds to be added to the time the test starts for a check. You'll see a loop containing a DoEvents statement - the program actually loops in there for the time allowed until the time is up or they click the [STOP] button I've provided. The DoEvents lets the system take care of other business like them entering their answers on the worksheet while the timer is keeping track of the time used. "Khaarthic" wrote: I have crated a worksheet for some mental sums. I would like to insert a timer function, say to complete 10 sums in 1 minute. How Can I do this? Can someone help? Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I insert AutoText in an Excel worksheet? | Excel Discussion (Misc queries) | |||
Insert a word doc as a worksheet in an excel workbook? | Excel Discussion (Misc queries) | |||
Cannot use Data Analysis tools on Excel worksheet embedded in PwrP | Excel Worksheet Functions | |||
Excel 2003, Convert EXISTING Worksheet Data to XML? | Excel Discussion (Misc queries) |