Force Users to answer survey questions

[MrGJEB]

I am putting together a simple feedback survey. I have a list of questions/statements that the user has to score from 1-5. (example: Rate the level of customer service you recieved).

I have used option buttons to represent the numbers 1-5 and these are linked to cells in a hidden sheet and are in a group box so that the user can only select 1 score for each question/statement.

When the questionnaire is completed the user clicks on a command button at the bottom which emails the workbook back to me.

My query is, how do i ensure that the user answers every questions, (ie, selects 1-5 for every statement). Is there any code i could andd to the command button that ensures at least 1 option button from each group box has been selected before sending the email.

Thanks

 

[hatepoppy]

I am putting together a simple feedback survey. I have a list of questions/statements that the user has to score from 1-5. (example: Rate the level of customer service you recieved).

I have used option buttons to represent the numbers 1-5 and these are linked to cells in a hidden sheet and are in a group box so that the user can only select 1 score for each question/statement.

When the questionnaire is completed the user clicks on a command button at the bottom which emails the workbook back to me.

My query is, how do i ensure that the user answers every questions, (ie, selects 1-5 for every statement). Is there any code i could andd to the command button that ensures at least 1 option button from each group box has been selected before sending the email.

Thanks

you say you have the option buttons linked to a workbook, sum the number of responses in another cell. when the user clicks the submit button, check if that cell's value is 5. if it is less, msgbox "try again". if not, proceed.

 

[MrGJEB]

Thanks, worked a treat.

 

[CIMS]

You might want to look into using a separate program to conduct a survey. With it being so difficult to get responses to surveys, you don't want to take any chances. There are websites out there that allow you to create surveys for free. Most of these websites also have a pay option if you want to access some of there more powerful features but from that sound of it, the free versions would be fine.

A few examples are surveymonkey.com, formsite.com, and zoomerang.com Hope this helped.