to ensure all radio button groups are used before moving on.

[lrm75uk]

Hi
I have created a survey in excel 2003.
It has 70 questions on it and the user responds to the questions by clicking on a radio button.
There are 4 radio buttons within a group box for each question and the user will select one of them.

At the end of 'sheet 1' with all these questions on, i have a button which the user presses to proceed to 'sheet 2'.
When they press the button i want to ensure is that all questions have been answered ie: 1 of the radio buttons is selected for every question.
If one of the questions isnt answered then a pop up box will appear to tell the user they have unanswered questions and then the vba code will exit and the user stays on the question sheet (sheet 1).
If all the questions are answered then the user will move to 'sheet 2'.

(the reference cells for all the groups of radio buttons are within column G on sheet 1).

I realy hope my explanation makes sense but would be glad to clarify if you can help.

Thankyou so much in advance.

[Palmetto]

There are a few ways to go about it, lacking details about your workbook here is one easy way.

Assuming you are using option buttons from the Forms Tool Box, you could use a helper cell to count the number of buttons checked and return either true or false:

Helper cell: =COUNTIF(G1:G2,">0")>=2
Code assigned to button:

Please Login or Register  to view this content.

[royUK]

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution. Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.
To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

Edited this time

[lrm75uk]

Thankyou so much for your proposed solution.
Your attachment was really helpful to see the code working thanks!
This is exactly what i was looking for.
Brill!