Storing user input through option button value in another worksheet row by row

[NRMDU]

Hi
It is a multiple choice answering project. Results will be displayed once the exercise is completed. I am unable to store the choice selected by the user against each question .

My code is like this:

Please Login or Register  to view this content.

After the option button click event the value should be stored in the "RESULTS" sheet in "I" column row by row.
My code is placing the value in the first row only.

Please help me in solving the issue

[Bishonen]

Please Login or Register  to view this content.

The ctr2 isn't magically saved somewhere within vba/excel. After you press next question or whatever the button is labeled, the vba code is done and all variables are reseted.

[AlphaFrog]

You could assign all the option buttons to this one procedure (the four procedures were are all identical)

Please Login or Register  to view this content.