Surveys in Excel!

[CuriousGeorg]

hi,

I've got a "design" issue here. I've been tasked to replicate a survey from Word in excel so that they can add the information and then analyse it later.

There's approximately 7 questions which are ALL free format questions (no 1-5 scales etc). I was curious as to the best way around this.

Of course I could use a userform to input the information but not sure this is the approach they would like.

Is there a way of emulating a user form on the excel sheet and then this then auto stores on say sheet 2 in the same workbook?

[Szaraq]

I would do it in one of two ways:
1) userform, as you said
2) classic worksheet with "submit" button, which would run a procedure, that would copy the answers from answer cells to the data table in sheet 2 and clear the answer cells. Eventually you can do the same, but instead of the button, you can add this procedure to for example Workbook_BeforeSave section.

[CuriousGeorg]

thanks Szaraq, glad we're on a similar wavelength.. User form it is.. Grin and bear it :D

[Szaraq]

Hehe, to be honest I would use the "submit button" solution :).