I'm trying to create a form or dependent list or ??? that will ask the user to answer a series of questions one at a time. The subsequent question wil

[mjtaxpro]

I'm trying to create a form or dependent list or ??? that will ask the user to answer a series of yes/no questions displayed one at a time. The subsequent questions will be determined by the previous answer. There will be approximately 15-20 questions, however a lot of the questions will be skipped based on the users answers. For example, if question 1 is answered no, the next question might be question 5 instead of question 2, etc. The end result needs to be the user being informed that yes they qualify based on the answers or no they don't qualify, and if they don't qualify, I'd like them to be informed of what answer disqualified them.

 

[JLGWhiz]

You could probably do what you want with a series of message boxes using VBA.
Here is an example:

Sub Teststuff()
Resp = MsgBox("Do you like movies?", vbYesNo, "Question 1")
    If Resp = vbYes Then
        resp2 = MsgBox("Do you like Gory Sci=Fi movies?", vbYesNo, "Question 2")
            If resp2 = vbYes Then
                resp3 = MsgBox("Do you like all types of movies?", vbYesNo, "Question 3")
                    If resp3 = vbNo Then
                        Cells(Rows.Count, 6).End(xlUp)(2) = "Movies OK"
                    Else
                        Cells(Rows.Count, 6).End(xlUp)(2) = "Movies Suck"
                    End If
            End If
    End If
Resp = MsgBox("Do you like Candy?", vbYesNo, "Question 4")
    If Resp = vbYes Then
        resp2 = MsgBox("Do you like chocolate candy?", vbYesNo, "Question 5")
            If resp2 = vbNo Then
                Cells(Rows.Count, 6).End(xlUp)(2) = "Not a choc head"
            Else
                Cells(Rows.Count, 6).End(xlUp)(2) = "Is a choc head"
            End If
    End If
End Sub

But no matter what you use, you will need the If...Then statements or Select Case statements to control the responses and record the results. I suggested the Message Box approach because it already had the Yes/No buttons built in.