Hi....I have a vba code that is using the values in 3 cells (drop down combo boxes) to bring the user to specific rows and columns on a specific sheet in my workbook (partial of the code is below). This is working beautifully. My problem is now if the value of "list3" equals "Other", regardless of the values in "list1" or "list2", I need a message box to pop up instead of bringing the user to another sheet. I can't seem to get this to work. There are over 150 different combinations of choices available in my list already so I'd prefer to use wildcards (*) for the "list1" and "list2" values and only have this line of code in once if possible. But I can add code in for each combination if that is what I need to do. I can't seem to get the write syntax to make it work. Any idea of how to do this and where to put the code? Thanks

Sub SelectionPage1_Button6_Click() 'SEARCHES FOR INSURANCE REQUIREMENTS ON THE MATRIX - FOR CONTRACTOR NEW PROJECTS
    Dim list1 As String, list2 As String, list3 As String
    
    list1 = Range("B14")
    list2 = Range("D14")
    list3 = Range("F14")
    
      If list1 = "CCDC5B" And list2 = "$100K or Less" And list3 = "Urban - Over 5 Storey" Then
      Sheets("CM-CCDC5B").Visible = True
      Sheets("CM-CCDC5B").Range("E1:E61").EntireColumn.Hidden = False 'works
      Sheets("CM-CCDC5B").Range("A4:L61").EntireRow.Hidden = False 'works
      Application.Goto Reference:=Worksheets("CM-CCDC5B").Range("A1"), _
        Scroll:=True
      Sheets("Selection Page1").Visible = False
      ElseIf list1 = "CCDC5B" And list2 = "$100K or Less" And list3 = "Urban - Under 5 Storey" Then