Questionnaire

[damo07]

Hi there,

I would be extremely grateful if someone could help me out here.

I am wanting to create a questionnaire for work. I will try to explain what I am looking for below.

First question for example:
Are you happy? (have a drop down box with yes/no).

If yes, then activate a note saying "thanks for your time" and the questionnaire finishes.
If no, then activate the next question.

Next question:
Do you enjoy work? (and a drop down box with yes/no).

If yes, then activate a note saying "thanks for your time" and the questionnaire finishes.
If no, then activate the next question.


And so on.

I would like it so that the next question is not visible until they have answered the previous question, and not visible at all if the answer was yes.

If someone can start me off, then I can extend the questionnaire!!

Many thanks,

Damian

[pierre08]

You'll have use:

Select Case MsgBox("Are you happy", vbYesNo)
 Case vbYes
 MsgBox "Thanks for your time"
 Case vbNo
    Select Case MsgBox("Do you enjoy work?", vbYesNo)
        Case vbYes
            MsgBox "Thanks for your time"
        Case vbNo
        '.......
    End Select
End Select

Hope this helps

[damo07]

Thanks for your prompt reply pierre08. Are you by any chance able to add a few more questions on?

Q3 Have you ever been laughed at?
No next question
Yes please be happy

(both answers still go to next question)

Q4. Are you strong?
No - no next question
yes - (provide a space to type something)

(both answers go onto next question)

Q5. Approved by you?
Yes or no

(display option to tick either yes or no)


Thank you very much for your help!!!