title: Check if string is in array or not including wildcards with Excel VBA
body: <p>I found this function to identify whether a string is in a given array, however it does not seem to be able to handle wildcards (or atleast not the way i do it).</p>
  
  <pre><code>Function IsInArray(stringToBeFound As String, arr As Variant) As Boolean
    IsInArray = (UBound(Filter(arr, stringToBeFound)) &gt; -1)
  End Function
  </code></pre>
  
  <p>My use of the function:</p>
  
  <pre><code>Dim BannedWildcards() As Variant
  
  BannedWildcards = Array("", "-", "?", 0, "na", "n/a", _
  "*account*", "*hse*", "*defined*", "*applicable*", "*operation*", "*action*", "*manager*")
  
              Select Case True
              Case IsInArray(LCase(Sht_Tracker.Cells(RowCounter_CRCT, 17)), BannedWildcards) = True
                  Arr_Dashboard_Current(10, ArrC_Dashboard_Current) = "#N/A"
              Case Else: Arr_Dashboard_Current(10, ArrC_Dashboard_Current) = Sht_Tracker.Cells(RowCounter_CRCT, 17)
              End Select
  </code></pre>