Can Excel create a counter and/or a timer

[Steve Toohey]

I have created a small spreadsheet that allows the user (a
young child) to practice their times tables. Press a
button and it randomly comes up with a times table sum,
type in your answer, press enter, if its correct it tells
you so and you press the button and get another sum. Get
it wrong and it tells you to try again

is it possible to develop a counter that tells you how
many sums youve done, or got right?

or is it possible to create a timer that gives the person
only a certain time to answer the sum?

 

[Frank Kabel]

Hi Steve
or your first question (creating a counter):
- if you already have a macro which tells you the answer is correct,
simply store this result in a separate cell and add 1 to this cell each
time you have entered a valid answer
- something like
Range("A1").value = Range("A1").value+1

Second question: Have a look at the OnTime method:
http://www.cpearson.com/excel/ontime.htm

 

[Bob Phillips]

Steve,

If you mail me your email address I will send you an interesting little
workbook I created for a trust here in the UK that does a similar function.

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

 

[Tushar Mehta]

On my web site, from the Excel page, click the
'Teach your kids arithmetic' link. The program keeps track of the
correct/incorrect answers, but there is no countdown timer.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Multi-disciplinary business expertise
+ Technology skills
= Optimal solution to your business problem
Recipient Microsoft MVP award 2000-2004