Help creating a Test using VBA and option buttons

Greetings,

I am not very savvy on VBA. I am trying to create a test in excel using option buttons. What I would like is:

1) A score button that only the examiner has access to (password protected). Once the score button is pressed, it will populate the total score in the appropriate field.

2) Ability to list which questions were answered incorrectly. (Only once "Score" button pressed)

3)Ability to reset the test by clicking on the image (password protected)

A few additions.
-This will be a template for other tests.
-Number of questions may change
-Not all questions will have 4 answers
-Will be printing the test
-If an answer sheet is needed, then will need to hide the sheet until admin password is entered.
-Needs to be done in excel

I know this is a lot to ask, but if anyone can help in the creation of this, I appreciate it. I am trying to create it myself, but again, I am not VBA smart.

Thank you

I think this is a big ask (as you have hinted). How about you take a different approach that doesn't use VBA so you can do it yourself.

1. Forget about your radio buttons.
2. add an answer column next to your questions, and ask the user to enter a, b, c or d. You can use DATA\Validation to prevent them entering anything else.
3. create a correct answer column with the right answer in it ie a, b, c or d.
4. create score column that uses a formula against each question to check their answer vs the right answer using a simple "if" statement. Give them 1 point (say) for a right answer and zero for wrong.
5. hide the correct answer column and the score column.
6. Protect the workbook so they can't unhide the hidden columns.

Someone will surely help you with a couple of macros to hide/unhide the columns when you have something close to finished.

Would that work?