How do I insert a timer in an excel worksheet?
in [General]
|
Prev: Help with an additing calculation
Next: Excel opens two windows (2007 & 2003 format): I want only 2003.
From: basstbone on 6 Mar 2010 14:34 :*(** 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 |