title: Userforms for setting multiple filter criteria
body: <p>I have 6 userforms which pop up and ask you to select the variables that you wish to sort:</p>
  
  <ol>
  <li>ClientFilter</li>
  <li>CostCenterFilter</li>
  <li>UtilityFilter</li>
  <li>TypeOfWorkfilter</li>
  <li>AnalystFilter</li>
  <li>ProjMgrFilter</li>
  </ol>
  
  <p>Inside each one it uses if statements to for each variable.</p>
  
  <pre><code>Sub UpdateCF()
      Integer_CF = -1
  
      If AU_CF.Value = True Then
          Add_CF String_CF, "AU"
          Range("$B$6:$AU$68").AutoFilter  _
                Field:=2, Criteria1:=String_CF,   _
                Operator:=xlFilterValues
      End If
  
      If AULaw_CF.Value = True Then
          Add_CF String_CF, "AULAW"
          Range("$B$6:$AU$68").AutoFilter  _
                Field:=2, Criteria1:=String_CF,   _
                Operator:=xlFilterValues
      End If
      ... 
  
  End Sub
  
  Sub Add_CF(String_CF() As String, NewValue As String)
      Integer_CF = Integer_CF + 1
      ReDim Preserve String_CF(Integer_CF)
      String_CF(Integer_CF) = NewValue
  End Sub
  </code></pre>
  
  <p>This works fine except I want to be able to sort on multiple fields. For example I would like to be to use The Client Filter and then select a variable then use the Cost Center Userform to be able to have both sorts enabled at the same time. </p>