VBA code for multiple choice quiz

Hi,

Trying to do a multiple choice (4) quiz, 50 questions, scored at end.

Questions are in column A
Multiple Choice Selections in columns B-E
Answer in Column F

Has a form with label for question, 4 option buttons for multiple choice answers and a <next> and <quit> button

Looked at coding solutions on the internet but they all rely on populating the questions in the code itself, too inefficient. Tried ChatGPT but I keep getting coding errors.

Any suggestions on how I should proceed?

Originally Posted by beyond Excel

Hello.
I think that understanding what you want to do does not present any degree of complexity.

However -I also think- that you could have presented a workbook that with a greater degree of certainty reflects what you have. That is why I am attaching another booklet that - I understand - is more similar to the one you have and to what you want to achieve: Could you look at it?...

Thank you, I might go with the simpler approach as my VBA coding is very rusty (been 20 years). Cheers