Creating a Survey Form

I want to create a survey form in excel 2003 using the option button.  There will be 3 option for each question.  
How the value of option buttons can be found out to summarise and produce a  chart out of the result.
aak313Asked:
Who is Participating?
 
jppintoCommented:
Here you can find a tutorial on how to create a survey in Excel:

http://www.contextures.com/xlform01.html

Here's another article about creating a survey:

http://www.brighthub.com/computing/windows-platform/articles/31430.aspx

One more tutorial on this:

http://www.spreadsheetconverter.com/home/survey/

Microsoft also addresses this on this page:

http://www.microsoft.com/Education/Designsurvey.aspx

Hope you find what you're looking for on these links.

jppinto
0
 
Michael FowlerSolutions ConsultantCommented:
The option buttons ned to be grouped and you can then use VBA to get the results.

This link should give you a start

http://www.contextures.com/xlform01.html

Michael
0
 
aflockhartCommented:
You can do surveys like this in Excel but it is often much easier to just use an online service like SurveyMonkey.

Dong it in Excel means you need to program the survey itself, then manage the process of getting the responses back, probably in multiple spreadsheets, and producing a single document containing all the responses.  
0
Cloud Class® Course: SQL Server Core 2016

This course will introduce you to SQL Server Core 2016, as well as teach you about SSMS, data tools, installation, server configuration, using Management Studio, and writing and executing queries.

 
patrickabCommented:
aak313,

One way of doing it is in the attached file.

Add questions to meet your requirements.

Patrick
Survey-form-01.xls
0
 
aak313Author Commented:
The form found  helpful.   Is there any way to use it to accept data instantaneously from multi users
0
 
patrickabCommented:
>Is there any way to use it to accept data instantaneously from multi users

No, there is not as Excel files must NOT be used in 'shared' mode.

Patrick
0
 
aak313Author Commented:
Thanks for all advises and solutions
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.