how would I right a code to randomly select from a list of questions an
then check for the answears, like a test

say I have 5 question such as what is 2*2, what is the captial o
france etc, I want the code to cycle through this question in a rando
fashion and check if the answears are correct...

please help, this is for purpose of testing and memorizatio

--
nyn0
-----------------------------------------------------------------------
nyn04's Profile: http://www.excelforum.com/member.php...fo&userid=1265
View this thread: http://www.excelforum.com/showthread.php?threadid=26199

hi,

add one column to the list and use the formula
=RAND()
to write a random numer in each row. Whenever you start your test
resort the list by this new column, then you can simply loop through
the list from the first to the last row. Remember, the list will be in
random order after (recalculating and) sorting!

maybe you should have another column that has numbers of the original
sort order. then you could sort by that column to get back your
original order.

arno

"nyn04" schrieb im Newsbeitrag
...

how would I right a code to randomly select from a list of questions
and
then check for the answears, like a test

say I have 5 question such as what is 2*2, what is the captial of
france etc, I want the code to cycle through this question in a
random
fashion and check if the answears are correct...

please help, this is for purpose of testing and memorization


--
nyn04
---------------------------------------------------------------------
---
nyn04's Profile:
http://www.excelforum.com/member.php...o&userid=12658
View this thread:
http://www.excelforum.com/showthread...hreadid=261991

how do you want to interact with the person answering the questions. Are
you writing the questions to a worksheet? Is it an interactive process
(inputbox, msgbox). where are the questions and answers located?

--
Regards,
Tom Ogilvy

"nyn04" wrote in message
...

how would I right a code to randomly select from a list of questions and
then check for the answears, like a test

say I have 5 question such as what is 2*2, what is the captial of
france etc, I want the code to cycle through this question in a random
fashion and check if the answears are correct...

please help, this is for purpose of testing and memorization


--
nyn04
------------------------------------------------------------------------
nyn04's Profile:
http://www.excelforum.com/member.php...o&userid=12658
View this thread: http://www.excelforum.com/showthread...hreadid=261991