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.

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" wrote in message
...
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.