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.