shuffle answers

  • Thread starter Thread starter RS
  • Start date Start date
R

RS

I want to create a test with mutiple choice answers,
there will be 5 answers to chose from with only one
correct. How can I shuffle the 5 answers so each test has
the answers in different order?

Thanks RS
 
RS said:
I want to create a test with mutiple choice answers,
there will be 5 answers to chose from with only one
correct. How can I shuffle the 5 answers so each test has
the answers in different order?
Click to expand...

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Use the VBA Randomize and Rnd() function. From the help file:

Dim MyValue
Randomize ' Initialize random-number generator.

MyValue = Int((6 * Rnd) + 1) ' Generate random value between 1 and
6.

- --
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQFsbToechKqOuFEgEQIRyQCgmMUSwlliG8MoRSO7WaligYNuhEkAn2Qq
cDiQwyZhooZI61t0Skg+PDsX
=uGk5
-----END PGP SIGNATURE-----
 
Back
Top