count and limit radio button selections

[klintonselkirk]

I want to take a poll with 4 answer options displayed as radio buttons. I
want to tally the number of each option chosen for a specific question and I
also want one of the options to be limited to the number of times it can be
chosen . i.e. Options are Definately, Sounds Good, Maybe and No Way there are
50 rows of activities only 5 may be answered as Definately When all user
answer I want to paste answers into one spreadsheet then look speciically at
activity X and count how many answered Definately, Sounds Good, Maybe or No
Way.

[Tom Ogilvy]

the approach would depend on where the option buttons came from (control
toolbox toolbar or forms toolbar).

in any event, you would link them to cells (control toolbox toolbar) or cell
(forms toolbar) and set up a formula to count the entries in the cells.

Implementing validation would require code I would think. The
implementation would be dependent on how you want to handle it.

--
Regards,
Tom Ogilvy


"klintonselkirk" <[email protected]> wrote in message
news:[email protected]...
> I want to take a poll with 4 answer options displayed as radio buttons. I
> want to tally the number of each option chosen for a specific question
and I
> also want one of the options to be limited to the number of times it can
be
> chosen . i.e. Options are Definately, Sounds Good, Maybe and No Way there
are
> 50 rows of activities only 5 may be answered as Definately When all user
> answer I want to paste answers into one spreadsheet then look speciically
at
> activity X and count how many answered Definately, Sounds Good, Maybe or
No
> Way.