title: Get values from a listbox on a sheet
body: <p>I have a listbox named ListBox1 on Sheet1 of an Excel workbook.</p>
  
  <p>Every time the user selects one of the items in the list, I need to copy its name to a variable named strLB. </p>
  
  <p>So, if I have Value1, Value2, Value3, Value4 and the user selects Value1 and Value3, I need my strLB to come out as Value1,Value3.</p>
  
  <p>I tried doing that <em>post hoc</em> with:</p>
  
  <pre><code>For i = 1 To ActiveSheet.ListBoxes("ListBox1").ListCount
      If ActiveSheet.ListBoxes("ListBox1").Selected(i) Then strLB = strLB &amp; etc.etc.
  Next i
  </code></pre>
  
  <p>But this is very slow (I have 15k values in my listbox). This is why I need to record the selection in real time and not in a cycle, after the user is done inputting.</p>
  
  <p>I'm going to also need a way to check if the user removed any of the previous selection.</p>