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)?