title: Trying to remove specific items from an already populated Combobox VBA
body: <p>In VBA I am writing a code that gathers information based off an initial input in a userform. </p>
  
  <p>From the initial entrance point I want the code to go out and find the corresponding data and add it. I have that all working well. </p>
  
  <p>But I am gathering the data from a pivot table and if the <strong>pivot table is open it returns "" spaces, "(blank)" and "Grand Total", which I want to get rid of</strong>. </p>
  
  <p>My Current code is:</p>
  
  <pre><code>lcomboCount = Sheets(pt).PivotTables("Pivottable1").TableRange2.Rows.Count
  For i = 1 To lcomboCount
  datapoint = Sheets(pt).PivotTables("PivotTable1").PivotFields("combo").LabelRange.Offset(i, 0).Value
  UserForm1.ComboBox.AddItem Sheets(pt).PivotTables("PivotTable1").PivotFields("combo").LabelRange.Offset(i, 0)
  Next i
  For i = 0 To Me.ComboBox.ListCount - 1
  If Me.ComboBox = "" Or Me.ComboBox = "Grand Total" Or Me.ComboBox = ("(blank)") Then
      Me.ComboBox.RemoveItem (i)
  End If
  Next i
  </code></pre>
  
  <p>I had a <code>Msgbox</code> in there at one point to see if my values were reading correctly and they were. </p>