random

[nyn04]

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

 

[arno]

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

 

[Tom Ogilvy]

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?