Survey

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

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.

..
"Tim" wrote:

> 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
>

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


>-----Original Message-----
>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.
>
>..
>"Tim" wrote:
>
>> 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
>>
>.
>

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.

"anonymous@discussions.microsoft.com" wrote:

> Thank you, I sent an email to the address you posted with
> my address. I appreciate the help.
>
>
> >-----Original Message-----
> >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.
> >
> >..
> >"Tim" wrote:
> >
> >> 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
> >>
> >.
> >
>

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

torrange@nospam.bellsouth.net

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

Tim
>-----Original Message-----
>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.
>
>"anonymous@discussions.microsoft.com" wrote:
>
>> Thank you, I sent an email to the address you posted
with
>> my address. I appreciate the help.
>>
>>
>> >-----Original Message-----
>> >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.
>> >
>> >..
>> >"Tim" wrote:
>> >
>> >> 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
>> >>
>> >.
>> >
>>
>.
>

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

"Tim" <anonymous@discussions.microsoft.com> wrote in message
news:606e01c524d0$46b5e350$a601280a@phx.gbl...
> 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