Any suggestions ?

[helplessnoobatexcel]

I have been tasked to think of a solution to help create a troubleshooting guide for users to refer when they encounter difficulties. There would be roughly a set of 20 questions that they would have to answer, with the starting questions being either a 'yes' or 'no' before progressing to other questions (broader ones, not really yes or no) based on their answers. Example: 1st Question: Did you try restarting your computer? If the answer the user input is No, then it would simply display the message of: try restarting your computer then and automatically end. If the answer the user input is Yes, then it would link to another question of: Have you sought technical support yet ?

Any ideas on how I can implement this on Excel ? I initially thought of using a flow chart but there is too many questions with the latter being broad questions so I would like a neater way to present it. Another solution I have is to create a table of questions of excel, which the user would input their values of either yes or no and based on their answers, it would act accordingly to open a new sheet to provide further answers but I'm not really sure how to implement it.. Any suggestions or help would be greatly appreciated!

 

[Logit]

Sub Team1()

 Dim msg As String, i As Long, a As Variant
    msg = ""
    
    For i = 1 To 2
        For Each a In Array("AC")
            msg = msg & Cells(i, a).Value & vbTab
        Next a
        msg = msg & vbCrLf
    Next i
    
    For i = 1 To 10
        For Each a In Array("U", "V")
            msg = msg & Cells(i, a).Value & vbTab
        Next a
        msg = msg & vbCrLf
    Next i
    
     For i = 1 To 10
        For Each a In Array("W", "X")
            msg = msg & Cells(i, a).Value & vbTab
        Next a
        msg = msg & vbCrLf
    Next i
    
    For i = 1 To 10
        For Each a In Array("Y", "Z")
            msg = msg & Cells(i, a).Value & vbTab
        Next a
        msg = msg & vbCrLf
    Next i
    
    For i = 1 To 10
        For Each a In Array("AA", "AB")
            msg = msg & Cells(i, a).Value & vbTab
        Next a
        msg = msg & vbCrLf
    Next i
    MsgBox msg, , "Staff Information"
    
  
  
    
    
    
End Sub

 

[Logit]

End Sub

[/CODE]

Download sample files : https://drive.internxt.com/sh/file/7727d05e-44bb-40ad-8e63-d59dd637bdf8/ab92884a62fc6275553c9bd8ada6bbd2cd5229af1468987ef4af181dba991b27

Use the YES / NO responses to select a sub macro leading the user to a followup page or to "kick" them out due to a wrong answer, forcing them to return to a previous page or
to begin all over. You can adjust the MsgBox in so many ways to suite your needs.

 

[helplessnoobatexcel]

Sub Team1()

 Dim msg As String, i As Long, a As Variant
    msg = ""
   
    For i = 1 To 2
        For Each a In Array("AC")
            msg = msg & Cells(i, a).Value & vbTab
        Next a
        msg = msg & vbCrLf
    Next i
   
    For i = 1 To 10
        For Each a In Array("U", "V")
            msg = msg & Cells(i, a).Value & vbTab
        Next a
        msg = msg & vbCrLf
    Next i
   
     For i = 1 To 10
        For Each a In Array("W", "X")
            msg = msg & Cells(i, a).Value & vbTab
        Next a
        msg = msg & vbCrLf
    Next i
   
    For i = 1 To 10
        For Each a In Array("Y", "Z")
            msg = msg & Cells(i, a).Value & vbTab
        Next a
        msg = msg & vbCrLf
    Next i
   
    For i = 1 To 10
        For Each a In Array("AA", "AB")
            msg = msg & Cells(i, a).Value & vbTab
        Next a
        msg = msg & vbCrLf
    Next i
    MsgBox msg, , "Staff Information"
   
 
 
   
   
   
End Sub

Hi Logit,
May I know what is this VBA code for?

 

[Logit]

These are examples using the Message Box from which you can create a selection for the user of Yes and No. You can also, with modification, edit the YES and NO to something else dependent upon your desire. You will need to study the code and see how you can implement the code into your project.