title: How to sort files and then populate a ListBox?
body: <p>This code populate a ListBox with the file names of a specific folder  </p>
  
  <pre><code>Dim DIRECTORY As String
  DIRECTORY = Dir(myPath &amp; "\*.xlsx", vbNormal)
  Do Until DIRECTORY = ""
  ListBox1.AddItem DIRECTORY
  DIRECTORY = Dir()
  Loop
  </code></pre>
  
  <p>But I want a sorted list.<br>
  How can I sort the files firstly and then populate the ListBox.<br>
  btw sorting a listbox is (as I know) a long procedure.</p>