I have a form with 10 questions each question has four options for answers
these are radio buttons that have frams around them - so they are mutually
exclusive. How to do I:
assign a value for each selection (assume 1 to 4 will be the same for each
questions) for each question and then have the sum of these appear in a text
box at the bottom (and get saved in a cell)?

Each group is assigned to the same linked cell. These will contain values
from 1 to 4. If they're all in the same column, just add them up! To have it
show up in a text box, create the box, and while it's active, click in the
formula bar, enter "=", click on the cell with the total.
Bob Umlas
Excel MVP

"gbpg" wrote:

I have a form with 10 questions each question has four options for answers
these are radio buttons that have frams around them - so they are mutually
exclusive. How to do I:
assign a value for each selection (assume 1 to 4 will be the same for each
questions) for each question and then have the sum of these appear in a text
box at the bottom (and get saved in a cell)?

I didn't expain this enough. The sheet the values go to is not visible. the
radio buttons and text box are on a form.

"Bob Umlas, Excel MVP" wrote:

Each group is assigned to the same linked cell. These will contain values
from 1 to 4. If they're all in the same column, just add them up! To have it
show up in a text box, create the box, and while it's active, click in the
formula bar, enter "=", click on the cell with the total.
Bob Umlas
Excel MVP

"gbpg" wrote:

I have a form with 10 questions each question has four options for answers
these are radio buttons that have frams around them - so they are mutually
exclusive. How to do I:
assign a value for each selection (assume 1 to 4 will be the same for each
questions) for each question and then have the sum of these appear in a text
box at the bottom (and get saved in a cell)?