The easiest approach is to first write the entries out to a blank worksheet
in column A, then sort column A. Then fill the list box with the entries.
You can get the code for sorting by using the macro recorder.
Bob Flanagan
Macro Systems http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel
I had thought of that approach, but it would require
changing how the listbox is populated. The listbox is
filled dynamically with all the files located in a folder
that the user selects. I could write those files to a
worksheet and sort the files and then populate the
listbox, but I was just hoping that there was a built-in
feature to do this. Thanks for the help...
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
