Surveys, anyone?

Todd K · Mar 21st, 2002, 05:25 PM

I am looking for a way to create a "user survey" system in Excel...criteria:
Must have responses in check boxes or pull-down boxes...
Must have a way of compiling the responses from a single user on a single sheet (the "Data" sheet)...
Must have a way for the user to automatically send back to me (the creator) just the data sheet by e-mail...

Nice to have would be an easy Master Control workbook that imports the values from each user's returned sheet automatically...

Anyone seen an implementation with Excel like this? Would be very appreciative...

AJ · Mar 22nd, 2002, 05:47 PM

At the risk of being no help to you in your specific request whatsoever, can I ask why you need to do surveys in Excel at all?
I work for a Market Research data processing company and it is of my opinion (and I believe the MR DP industry as a whole in the UK) that Excel is not the best tool for the job.
Sure, it's possible. However, the labour required in setting up the survey is far more than justifies the means. If you need to do a user survey in this fashion, my preference would be a web survey.
You can see the sort of thing that is possible by following the www link below and looking for Inweb.
Apologies for the shameless plug, but the key message is that there are better ways of doing this than an Excel application (in my humble opinion!).

Rgds
AJ

Al Chara · Mar 22nd, 2002, 06:06 PM

Todd,

This is all possible in excel. Take a look at creating a userform with comboboxes, checkboxes, optionbuttons, textboxes. Link the values of these boxes and buttons to cell ranges in your data worksheet. Use the command workbook.sendmail to email the data back to you. Post specific questions as you come across them.

_________________
Hope this helps.
Kind regards, Al.

[ This Message was edited by: Al Chara on 2002-03-22 17:06 ]

Jack in the UK · Mar 23rd, 2002, 05:50 AM

Hi --

To add, i dont see why Excel cant be used to opperate this task, forms, ticks and drop donws and all the rest will make this possible and a rich project.

the survey is a project and needs to be addressed as such so your need to build stage by stage, like the earlier posts best approach will be to attack the step by step and post each stage to get ideaqs and anwers to bits you get stuck on,

I use this board to ask help and many readers will say why is JACK asking that im know he knows the answer, i use this board and friends as a rich libary of advice help and IDEAS, which they all help soi very much, i post small snips to get different ideas.

Back to the survey no fixed approach and will depent on hat an d how you decide you waht things to look and run your call..

I have a survey i did work on its rubbish really poor but never really to the level you want, can post it you like, but its poor but at least will spur some ideas, this was used and so can have some good i guess.

No complaints is rough!

If you want email on my profile and ill send soon as email working at work again.

Good luck.. all wil be fine but will take a lot of effort and evelopement to be really slick and nice, im sure you get there

Ceara · Jul 17th, 2002, 02:46 PM

I have had to create a survey in excel recently. What helped the most was http://www.fontstuff.com: If you will go to the download section, There is a userforms download. Very good for starting a survey form in excel.
If you would like to peak at the excel workbook that my sister and I have been working just let me know.
cearamerkle@yahoo.com

Mar 23rd, 2002, 05:50 AM	#4
Jack in the UK Board Regular Join Date: Feb 2002 Posts: 3,065	Hi -- To add, i dont see why Excel cant be used to opperate this task, forms, ticks and drop donws and all the rest will make this possible and a rich project. the survey is a project and needs to be addressed as such so your need to build stage by stage, like the earlier posts best approach will be to attack the step by step and post each stage to get ideaqs and anwers to bits you get stuck on, I use this board to ask help and many readers will say why is JACK asking that im know he knows the answer, i use this board and friends as a rich libary of advice help and IDEAS, which they all help soi very much, i post small snips to get different ideas. Back to the survey no fixed approach and will depent on hat an d how you decide you waht things to look and run your call.. I have a survey i did work on its rubbish really poor but never really to the level you want, can post it you like, but its poor but at least will spur some ideas, this was used and so can have some good i guess. No complaints is rough! If you want email on my profile and ill send soon as email working at work again. Good luck.. all wil be fine but will take a lot of effort and evelopement to be really slick and nice, im sure you get there __________________ Free Excel based Web Toolbar available here. Jack in the UK J & R Excel Solutions "making Excel work for you"

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 21st, 2002, 05:25 PM	#1
Todd K New Member Join Date: Feb 2002 Posts: 31	I am looking for a way to create a "user survey" system in Excel...criteria: Must have responses in check boxes or pull-down boxes... Must have a way of compiling the responses from a single user on a single sheet (the "Data" sheet)... Must have a way for the user to automatically send back to me (the creator) just the data sheet by e-mail... Nice to have would be an easy Master Control workbook that imports the values from each user's returned sheet automatically... Anyone seen an implementation with Excel like this? Would be very appreciative...

Mar 22nd, 2002, 05:47 PM	#2
AJ Board Regular Join Date: Mar 2002 Location: =ActiveCell.Address Posts: 478	At the risk of being no help to you in your specific request whatsoever, can I ask why you need to do surveys in Excel at all? I work for a Market Research data processing company and it is of my opinion (and I believe the MR DP industry as a whole in the UK) that Excel is not the best tool for the job. Sure, it's possible. However, the labour required in setting up the survey is far more than justifies the means. If you need to do a user survey in this fashion, my preference would be a web survey. You can see the sort of thing that is possible by following the www link below and looking for Inweb. Apologies for the shameless plug, but the key message is that there are better ways of doing this than an Excel application (in my humble opinion!). Rgds AJ

Mar 22nd, 2002, 06:06 PM	#3
Al Chara MrExcel MVP Join Date: Feb 2002 Location: Monterrey, Mexico Posts: 1,433	Todd, This is all possible in excel. Take a look at creating a userform with comboboxes, checkboxes, optionbuttons, textboxes. Link the values of these boxes and buttons to cell ranges in your data worksheet. Use the command workbook.sendmail to email the data back to you. Post specific questions as you come across them. _________________ Hope this helps. Kind regards, Al. [ This Message was edited by: Al Chara on 2002-03-22 17:06 ]

Jul 17th, 2002, 02:46 PM	#5
Ceara New Member Join Date: Jul 2002 Location: Tulsa, OK Posts: 2	I have had to create a survey in excel recently. What helped the most was http://www.fontstuff.com: If you will go to the download section, There is a userforms download. Very good for starting a survey form in excel. If you would like to peak at the excel workbook that my sister and I have been working just let me know. cearamerkle@yahoo.com