Quiz...
 

Could anyone help me out, i've just created a quiz in excel & i'm just
wondering if anyone knows how i go about clearing the answers & totals after
users complete the quiz? so its ready for the next person to have a go at.The
answers are in drop-down boxes, so i was also wondering if anyone knew of a
way to limit users from only having one choice from the drop down menu
therefore if their answer is wrong it's wrong!!

Quiz...
 

If they only have one choice, and its wrong, then you are wrong, not them?
--
Hth

Kassie Kasselman


"tiarna" wrote:

Could anyone help me out, i've just created a quiz in excel & i'm just
wondering if anyone knows how i go about clearing the answers & totals after
users complete the quiz? so its ready for the next person to have a go at.The
answers are in drop-down boxes, so i was also wondering if anyone knew of a
way to limit users from only having one choice from the drop down menu
therefore if their answer is wrong it's wrong!!

Quiz...
 

Have a look around www.quizardry.com where you will find Excel quiz files and
also some blank files to create your own

"tiarna" wrote:

Could anyone help me out, i've just created a quiz in excel & i'm just
wondering if anyone knows how i go about clearing the answers & totals after
users complete the quiz? so its ready for the next person to have a go at.The
answers are in drop-down boxes, so i was also wondering if anyone knew of a
way to limit users from only having one choice from the drop down menu
therefore if their answer is wrong it's wrong!!

Quiz...
 

Depends on what you used to create the dropdowns, too.

You may want to be more specific -- did you use data|validation, dropdowns from
the Forms toolbar, comboboxes from the control toolbox toolbar???

tiarna wrote:

Could anyone help me out, i've just created a quiz in excel & i'm just
wondering if anyone knows how i go about clearing the answers & totals after
users complete the quiz? so its ready for the next person to have a go at.The
answers are in drop-down boxes, so i was also wondering if anyone knew of a
way to limit users from only having one choice from the drop down menu
therefore if their answer is wrong it's wrong!!

--

Dave Peterson