Survey

[Tim]

Hello All,

I am trying to create a questionnaire that will contain
about 50 questions with multiple choice responses. I
would like to do this through an userform. Can someone
send me to a site or maybe help me get started. I guess
my hang-up here is how to do this simply.

Thanks

 

[Guest]

Tim,
I recently created a questionnaire using a multi-page userform to
enter the responses. Each response is a button (but could be a
checkbox/option button) to avoid typing in data. The code "converts" the
button response into a value which is stored in a worksheet.

It will also create a results page and generate pie charts for selected
questions.

The userform is dynamically created from data held in a worksheet and hence
is fairly generic.

If this could be of use, I could e-mail to you.

..

 

[Guest]

Thank you, I sent an email to the address you posted with
my address. I appreciate the help.

 

[Guest]

No email as yet - maybe my spam filter removed you (I automatically delete
any spam).

I'll wait until tomorrw (UK time) to see if I get reply; otherwise are you
willing to post here?

Toppers.

 

[Tim]

Here is my email with a spam block in the middle, remove
the "no spam." and that is my address.

(e-mail address removed)

Sorry, I posted my email once and got nailed with spam.
Once again, I really appreciate your help.

Tim

 

[Michael R Middleton]

One way "to do this simply" might be to not use Excel for the questionnaire.
Instead, use one of the browser-based online survey services. (Just type
"online survey" into Google.) Then use Excel to summarize and analyze the
survey results.

- Mike www.mikemiddleton.com