This may help:
http://www.contextures.com/xlForm01.html
from Debra Dalgleish's site.

AJM wrote:

I have created a question form that has 5 option buttons for each question. I
want a separate cell to generate a corresponding number(1 - 5) for the button
being pressed. Is this possible and how do I do it?

Thank you in advance for the advice.


--

Dave Peterson