Quantifying Results From Survey

[Mordred]

Hi all,

For a GUI assignment, we have been encouraged (for extra marks) to do some data gathering regarding our main project we are working on. Being that I am somewhat of an Excel junky, I thought I would create a survey form for this purpose. I have 4 yes/no questions, 2 Likert scales, and 1 open ended suggestion box. How can I tabulate the selections from the survey? I have tried a couple of ways ie: boolean and simple additions of selections but they do not produce accurate results. I would also like to know how to extrapolate the text inputted into the text box by the user. Finally, I can't quite seem to figure out how to submit the survey. I know this is asking a lot but I don't need all of the work done for me, as usual I just need a nudge in the right direction. Please see the attached workbook. Thanks.

Regards:

So I've got Unload Me (forgot that one) and can extract the text but I can't quite find what I am looking for as far as tabulating results of this little survey.

Edit: I have nothing to add here as my work thus far is incorrect.

Well, I think I've got this after burning the midnight oil. The form will auto load upon open and also when sheet3 is selected. I am going to add more and better, relevant questions, now that I know what I am doing. I am also going to hide the sheets once I go live with this and possibly even autoclose the book once the person submits the survey. Is that a good idea to do that? I don't know as this is completely new to me.

[teylyn]

Mordred, after your edits and comments like "(forget that one)" I'm no longer sure what you're asking. What exactly is your question?

[Mordred]

Hi teylyn, "forgot that one" was with reference to closing a form when finished with it. My posts were all put into one for some reason which no longer represents the progression of my events in my early hours. Its all good though as a I think I am finished the hardest part of this.