Survey Form

[John]

Hello,

I want to take a poll with approx 5 answer options displayed as radio
buttons or check marks. i.e. Options are Monday, Tuesday, Wednesday,
Thursday, Friday, When all users answer, I want to paste answers into one
spreadsheet then look at
activity X and count how many answered Monday, Tuesday, Wednesday, Thursday,
Friday. Any suggestions on how to start would be great.

Just remeber that I'll be sending the workbook as an attachment via email to
everyone. I would like to make it's as simple as possible for them to open
answer and resend back to me. Thank you.

John

[moondark]

Hi,

I created a Spreadsheet with the name "Start" and added 5 Optionbuttons named "Choice1" to Choice"5" and a commandbutton to execute the code and to vote.

The following code works but I'm not absolutely sure if it fits your needs

Please Login or Register  to view this content.

it's rather simple and therefore not dynamic (,yet).
But I preferred plain code, you can learn from

The code creates a Sheet called "Result" if it doesnt exist and writes the values of the optionbuttons in Cells A1 to A5. I didnt work on Headlines a.s.o. because everyone has his own design
You could also add a code fragment that checks if there is an optionbutton selected (if not then msgbox("alert"))
something like that.


Regards,

Simon