title: Sort List-box Conditionally without changing the Row-source
body: <p>If I got a list box say lstABC with 3 columns A, b &amp; c.
  And there is 3 sorting buttons say btnSortA, btnSortB, btnSortC.
  Is there a way to use the on_click event on the buttons that allow the user to sort lstABC without changing lstABC.rowsource every time?</p>
  
  <p>I was trying to achieve something in the line of this:</p>
  
  <pre><code>Private sub btnSortA_Click()
   lstABC.Orderby = "ColumnA ASC"
   me.lstABC.OrderByOn = True
  End Sub
  </code></pre>
  
  <p>Sure I could build SQL strings and set/requery lstABC.rowsource = string(for every button), but I am looking for something simple and efficient that don't overcomplicated things. Thanks</p>