Hope this all makes sense

In my spreadsheet are a number of questions in column B. The question is displayed in the text box and the answer is inputted into the same row in column R. The program then moves down a row and displays the next question and again inputs the answer into column R and so on.

I get to a point where there is a block of 4 questions about a sibling(Again all answers go in column R) The 4th question is in the form of VBA YES/NO box asking the user if they wish to add details about another sibling. If they answer yes then the block of 4 questions is repeated again and again. If they answer No then the program will just move onto the next question.

Here's the problem - I don’t want to put a limit on the number of siblings which can be entered so what I am trying to do is have it so the answers first time round are inputted into column R, if they select yes for the second time then the answers are inputted into column S and so on and so on.

Please Login or Register  to view this content.
Thanks

Will