title: Excel Combo Box Refresh Dropdown?
body: <p>Is there a way to refresh a combobox? 
  I have the following VBA code. The dropdown is populated, until the If statement where the list is cleared and populated with the matched items. </p>
  
  <p>At this point, the dropdown list only shows a single item with a scroll bar. But If I close the pulldown and reopen, it's fully populated correctly.</p>
  
  <pre><code>Private Sub ComboBox_SiteName_Change()
  ComboBox_SiteName.DropDown
  
  Dim v As Variant, i As Long
  With Me.ComboBox_SiteName
   .Value = UCase(.Value)
   If .Value &lt;&gt; "" And .ListIndex = -1 Then
     v = Worksheets("Address").Range("Table5[[#All],[SITE NAME]]").Value
     .Clear ' Clear all items
     ' Repopulate with matched items
     For i = LBound(v, 1) To UBound(v, 1)
       If LCase(v(i, 1)) Like "*" &amp; LCase(.Value) &amp; "*" Then
        .AddItem v(i, 1)
       End If
     Next i
    Else
    ' Repopulate with all items
    .List = Worksheets("Address").Range("Table5[[#All],[SITE NAME]]").Value
    End If
   End With
  End Sub
  </code></pre>
  
  <p>The ComboBox_Change function gets called as the user types in the combo box.. the dropdown box turns from a list into a single line with Up/Down arrows after the Clear and Repopulate matched items.. 
  but if I close the dropdown portion and reopen it lists all the items without Up/Down arrows. 
  The .ListRows value = 8 by the way. </p>
  
  <p>I would like a way for the dropdown potion to either close and reopen.. or a VBA function to refresh the dropdown portion, Without external buttons or controls Please</p>