Multiple Choice (Questionnaire/Survey) generator

Vishesh's picture

Here is an utility to generate a simple multi choice questionnaire/survey (as you wish to use it). The survey response files can be collated using the collate responses button and selecting the created files

Multi Choice

Questionnaire.xls73 KB

How to change answers on this questionnaire/survey

Dear Vishesh,

Can you please help me. I want to use your excellent questionnaire/survey, but I cannot change or input longer list of answers, or to change answers...

For example every question need to be scale from 1-5, 1 for important up to 5 not important, 1 strongly disagree - 5 fully agree

Can you help me please :(

Change the "quest" type to "radio" in any row in his tool

You can change the type quest to another type like radio by selecting type in column A

Question regarding questionnaire.xls

Hello Vishesh, Your Excel based survey is a very useful worksheet. I have modified it to enable surveys for a safety program. My question is: For a specific question, can one of the radio buttons within the answer group for the question be set such that a default radio button is marked when the spreadsheet is created? How would I modify the macro to enable this? I look forward to your response and help. Thank you for this assistance. With regards, Amitabha Kumar 

Extremely helpful. Saved me

Extremely helpful. Saved me from tons of work. One question though, is it possible to add a limitation to maximum answers checked, in checkbox kind of questions. Ty again for this amazing utility.

Nice Tool

Pretty impresive tool, but I receive an Error 400 when I will create the questionnaire.
Do you have any recommmendations?
Thank you.

Vishesh's picture

400 error

the tool was fine before, received the same error message week ago, checked addin folder, no file as "Spreadsheet Assistant 2007 2010.xla" was found, looks like it never exists

Very useful tool!

Very helpful tool for a project I'm working on, could you share the code for me to make modifications?

Questionnaire - Vishesh on 13 March, 2012 - 21:43

After the QUESTIONNAIRE is prepared
How does the participant answer the survey - by selectin the radio buttons after answering all questions

Why there is no submit button

Hidden Data.

Thank you for this development tool - very nice.

Need assistance though - it will only generate 75 lines into the form. My survey is much longer. Can you help?

Thank you in advance.