title: VBA Refresh UserForm ListBox Data when source changes
body: <p>Hi I have encountered problem with my listbox data in my Userform
  When I try to change the source file where my listbox connected it doesn't seems to change</p>
  <p>It was showing good data at first but when I try to click RUN DATE button</p>
  <p><img src="https://i.stack.imgur.com/Ll79Z.png" alt="enter image description here" /></p>
  <p>It doesn't go with the Value in my Range that is being set as My key for sorting</p>
  <p><img src="https://i.stack.imgur.com/d7CGN.png" alt="enter image description here" /></p>
  <p>Here is my code for RUN DATE BUTTON for sorting Ascending and Descending</p>
  <pre><code>Private Sub CommandButton1_Click()
  
  Application.EnableEvents = False
  
  Worksheets(&quot;combobox_value&quot;).Activate
  Dim strDataRange As Range
  Dim keyRange As Range
  Set strDataRange = Range(&quot;I2:L4&quot;)
  Set keyRange = Range(&quot;I2:I4&quot;)
  
  If Range(&quot;M2&quot;).Value = &quot;D&quot; Then
  
  strDataRange.Sort Key1:=keyRange, Order1:=xlDescending
  Range(&quot;M2&quot;).Value = &quot;A&quot;
  Else
  strDataRange.Sort Key1:=keyRange, Order1:=xlAscending
  Range(&quot;M2&quot;).Value = &quot;D&quot;
  End If
  Application.EnableEvents = True
  End Sub
  </code></pre>
  <p>And this is how I initialize the value in my listbox</p>
  <pre><code>Private Sub UserForm_Initialize()
  'set ListBox properties on initialization of UserForm
  Set sht = ThisWorkbook.Worksheets(&quot;combobox_value&quot;)
  lastRow_combobox_column = sht.Cells(sht.Rows.Count, &quot;I&quot;).End(xlUp).Row
  
  
  With ListBox1
  .ColumnCount = 4
  .ColumnWidths = &quot;100&quot;
  .ColumnHeads = False
  .ControlTipText = True
  End With
  
  'Load Worksheet Range directly to a ListBox:
  Dim var As Variant
  
  
  var = Sheets(&quot;combobox_value&quot;).Range(&quot;I2:L&quot; &amp; lastRow_combobox_column)
  
  
  Me.ListBox1.List = var
  
  
  End Sub
  </code></pre>
  <p>Is there a way to refresh my listbox? Listbox1.refresh something like that?</p>
  <p>Note: I don't need to close my Userform and open again to see the updated listbox
  so while the Userform is in active mode(Open) I can directly update the listbox value..</p>
  <p>Thanks</p>