Limit Number of Quiz Attempts to 3

[EliseFreedman]

Hi There

As Part of a work project, I have designed a quiz in excel.

The quiz contains a question set from which a set of 10 random questions are selected and loaded into the template each time the quiz is taken.

When the employee starts the quiz, they input their clock number and associated details. The quiz is then taken and they have to get a minimum of 80% to pass.

The final bit of the puzzle that I cant work out how to do is to kick the individual out after 3 attempts at the quiz if they have not passed. I have managed to record the clock number of each attempt in a hidden worksheet but not sure how to generate a message when the number of attempts for any one clock number reaches 3

Can anyone help? I have attached a copy of my spreadsheet

 

[DjangMan]

When you say "kick the individual out", do you mean to close down the workbook/Excel or are you keeping that user from getting back into the workbook again or for a period of time?

 

[EliseFreedman]

Hi DM

I meant to close down the workbook having displayed. Message telling them that they have reached the max number of tries and need to book onto a classroom course

 

[combo]

If the attempts can be saved locally for user, you can use safe VB and VBA section of the registry managed by SaveSetting, GetSetting, GetAllSettings and DeleteSetting.

combo

 

[Andrzejek]

When the employee starts the quiz, they input their clock number and associated details

After this step, check the number of attempts for entered clock number (employee?) [since you said: "I have managed to record the clock number of each attempt in a hidden worksheet"] and if number is > 3, MsgBox and kick them out.





---- Andy

There is a great need for a sarcasm font.