Link the tick boxes to cells in the worksheet. Then use the countif
function to tally responses. Obviously, the ease of this will depend on the
design.

--
Regards,
Tom Ogilvy

"Working with survey responses" <Working with survey
responses@discussions.microsoft.com> wrote in message
news:C793890A-8FC7-476D-BA13-F4A6B5B90EFB@microsoft.com...
> I want to design a questionnaire for staff to tick boxes and email back to
> me. What do I then do with the response sheets and how do I automatically
> calculate the responses from the sheets.
>