#1   Report Post  
Posted to microsoft.public.excel.programming
tim tim is offline
external usenet poster
 
Posts: 105
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,339
Default Survey

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

  #3   Report Post  
Posted to microsoft.public.excel.programming
No Name
 
Posts: n/a
Default Survey

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

.

  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 4,339
Default Survey

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.

" 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

.


  #5   Report Post  
Posted to microsoft.public.excel.programming
tim tim is offline
external usenet poster
 
Posts: 105
Default Survey

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



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.

" 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

.


.



  #6   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 9
Default Survey

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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Survey Pam Cole Excel Discussion (Misc queries) 2 January 14th 10 12:58 AM
survey Pammy Excel Discussion (Misc queries) 1 October 20th 08 07:57 PM
Survey raulmott New Users to Excel 0 June 25th 08 01:06 AM
Survey Tabulation grgh228 Excel Discussion (Misc queries) 0 February 13th 07 02:04 AM
survey Sherry Excel Discussion (Misc queries) 6 May 20th 06 03:36 PM


All times are GMT +1. The time now is 04:36 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"