sahafi -

It seems we have a difference of opinion. I do not regard writing VBA code
for your task to be "really simple." Instead, I think that using an
"off-the-shelf" application like SurveyMonkey is "really simple."

But, if you really want to do it yourself, please describe what you have
done so far and what problems you're having. There are lots of experts in
this newsgroup who can assist you.

- Mike


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