Basic question on questionnaire generator

Hi all,

I'm new to this forum and also kind of new to VBA. I hope my question isn't to "basic" and you would like to help me. I'm keen on getting insight on how to work with VBA and learn more!

My problem is:

We have a questionnaire, which is devided into several parts. I want to have a tool which produces (or generates ;)) a questionnaire which is based on the previous selection of parts.
For example I want to have an excel file with a tab, where I could choose the different parts which I would need. In the second tab you could find the whole questionnaire with all parts. I now want to develop a tool which would produce a questionnaire in a new excel file, based on the selected parts. I think this is a function, which I could also achieve only with excel, but I want to do it in a "smoother" way. Also I think it's a good way to start with working with VBA.

The question now is, is it possible to do this with VBA and how should I start?

I hope you can help me, and I won't get thrown out of the forum for such a basic question ;)

Thank you very much!

Nick's picture

take a look at

take a look at this:
http://excelexperts.com/multiple-choice-questionnairesurvey-generator

it won't answer all of your Q's but a good start.