Generate the number of an optionbutton in a cell

[Ype]

I want to create a multiple choise test in MS Excel 2007.


A question is stated on top of the groupbox. 3 Optionbuttons are in that box and hold the answers in the caption.
To create a list so i can compare questions and answers i create two collums; one containing the correct number of the optionbutton with the correct answer in the caption, the other containing the answer given by the user.

Thus I want put 1,2,3 in a cel according to wich optionbutton is selected. But i want to repeat this several times (so i can create different multiple choice questions).

This might be very easy for most of you, but I can't seem to get it working.

 

[Ype]

I hope the question is easy to understand.
If not, let me know.

Thanks in advance.

 

[Ype]

Going to bed, hoping in the morning an answer will be found.
Thanks in advance (again).