Sorting within an array, or in a combobox

[JP Romano]

Hello all,
Anybody out there know if there is a way to sort data in an array, or alternately, to sort in a combobox?

Here's the situation...
I have a userform with a combobox. That combobox is being populated by an array, which is storing filenames from a network directory. The code I'm using is below... basically, grabbing filenames from the directory and throwing them into the array. Then when the userform initializes, using that array to populate the combobox.

Please Login or Register  to view this content.

So, is there a way to alphabatize the filenames, without first writing them to the sheet?

Thanks for any input!

[jaslake]

Hi JP

Look at this link...I've used the code successfully in the past http://www.cpearson.com/excel/SortingArrays.aspx

[Krishnakumar]

Hi,

In a standard module

Please Login or Register  to view this content.

In userform module

Please Login or Register  to view this content.

HTH

[JP Romano]

Wonderful... thank you guys so much! Works like a charm!

[snb]

Why not using Excel ?

Please Login or Register  to view this content.

[JP Romano]

SNB, as I'm being asked to do more and more with Excel/VBA here at work, I try to find better, faster, smarter ways of doing things with each effort. With this little project, I wanted to force myself to use arrays, which are very new and interesting to me. My interest wasn't only in the end point, but different ways to get there. Hope that makes sense, and as always, thanks for taking the time to read and offer something incredible!

[shg]

One more alternative:

Please Login or Register  to view this content.