Form in Excel and saving records

[tinkerbelle]

Hi everyone.

I am using Excel to help capture responses from a survey form. The form is attached for your information in zip form.

You can see the questions in column 1, column 2 is effectively the first questionnaire responses. You will see that some of the answers are defined by validation drop-down boxes.

Is it possible to write a macro that would allow the user to enter each response, then click a button to SAVE the record, and this data would then be written to another worksheet called "Records" and transposed.

I guess we would also wish to be able to call up any record already saved, but that would be an added extra if anyone knows how to do it.

Another thing, If the user selected "other" in line 24 can a macro force them to enter an answer in line 25 ?

Thanks so much for your help.

[royUK]

See the examples contactsform.zip & databaseform.zip here

http://www.excel-it.com/vba_examples.htm

They could be adapted to do what you want

[tinkerbelle]

Thanks Roy, will certainly give it a go...