title: sorting a listbox in VBA
body: <p>I have a listbox with values. Now I need to sort that listbox, BUT NOT BY ALPHABETICALLY. </p>
  
  <p>You see the values in a listbox are from a table. </p>
  
  <pre><code>------------------------
  | name | order |  size |
  ========================
   value1   4
   value2   3
   value3   1 
   value4   2
  </code></pre>
  
  <p>I hope I made myself clear. So the list box has the items "value1, value2, value3, value4". I want it to sort by the order declared in the table. The list box has nothing to do with the table and is not "data bound" to it. The values come from somewhere else. </p>
  
  <p>Tech used: VBA, Access 2007</p>