Thanks for the suggestions, but I think what i'm looking for is really
simple, I just needs some directions on it.

How can I develop a user form with only 6 questions, and each question has
6-8 possible answers in addition to a combobox that populate a user name,
then when the user finishes answering all questions, I need all the answers
along with the user name to be saved somewhere, so I can tally the answers
together.

Thanks.
--

"Mike Middleton" wrote:

sahafi or Oz. -

Instead of "reinventing the wheel," consider www.surveymonkey.com or a
similar solution.

If you don't like the summaries provided by surveymonkey, download its data
file results of your survey, and use Excel for additional analysis.

- Mike
http://www.DecisionToolworks.com
Decision Analysis Add-ins for Excel


"sahafi" wrote in message
...
I need to create a form to run a survey on 50 users. I have 6 categories,
and
each category will have between 6 to 8 statements. Each category will be
in a
form with 6-8 option buttons for the user to select only one options then
move to the next form/catrgory, and so forth. I need to include a cobobox
from which the user can select their name, I also would like some kind of
mechanism to store user results and tally them in one area.
I know how to work that in Access pretty well (multi-page form or
Switchboard from which a user can navigate to individual forms back and
forth, select their names from the dropdown list and have the results
stored
in a table. But most of my users don't have Access, so I have to do it in
Excel, and i'm not sure how to work that in Excel (2002). Any help is
greatly
appreciated. Or if someone suggesting a competely different rout, i'm open
to
any idea as well.

Thanks.
--
Oz.