Userfrom next/back button to toggle

Hi Guys,

I would be really grateful if someone could tell me how to create a user form to toggle between text in a label box. Let me elaborate more;

What I want to achieve is something like a questionnaire.

In the user form, there will be a label box (label1), a text box(Textbox1) and two command buttons, one functions as a "Next" and the other as "Back" (CommandButton1 and CommandButton2 respectively).

There will be a question in the label box (question 1) and user is supposed to answer for it in the text box (TextBox1) in front (answer 1). Once done, user will click on "Next" command button. When user click this "Next" button, I want the question appearing on the label box to be changed to the second question (question 2) and then user can answer (answer 2) to that question in the text box (TextBox1). In any case if the user wants to go to the previous question, can simply click the "Back" command button ("Command Button 2") and the previous question would be displayed in label box.

Now, the answers that the user key-in in the text box (Textbox1) should be recorded in a excel worksheet (Sheet1) in a column in vertical direction. Meaning to say that if the answer to the "question 1" goes to cell "A1" and the answer to the "question 2" goes to cell "A2" and so on.

I hope the question is clear and sincerely hope somebody would help me with this or direct me to somewhere (a website, forum may be) where I can find some guidance on how to solve this.

Thank you so much in advance guys and thank you so much for taking time to read and understand my question. Please reply to this thread if you need any further clarifications etc...

Thanks a million

Yours Sincerely,
Dev

Questions & answers should be on the Forum not emailed. Also, posting your email address invites spam!

Where are the questions stored

This might help

Please Login or Register  to view this content.

The easiest option would be to store the questions on a worksheet.

Please Login or Register  to view this content.

Attach an example workbook of how you would have the questions & answers.