ListBox Fill

[cstimart]

Is it possible to tweak this so the results are in alpha order?

Private Sub UserForm_Initialize()
MyFile = Dir(MyFolder & "Report *.xlsm")
Do While MyFile <> ""
    FileListForm.ListBox1.AddItem MyFile
    MyFile = Dir
Loop
End Sub

 

[jolivanes]

http://www.excelforum.com/excel-programming/784354-sort-an-array.html

You might find something in the above thread