Sort an Array

Is it possible if I create an Array that I can then sort it alphabetically through code?

The reason I am asking this is I am creating an Array out of a Range on a WorkSheet to fill in to a listbox but then I want the array elements in alphabetical order so users can find things as easily.

Here is sample code for what I am talking about:

Please Login or Register  to view this content.

Keep it simple:

Please Login or Register  to view this content.

sorted

Please Login or Register  to view this content.

Hi djblois1

It sounds as if your doing this in a UserForm. If so, try this

Please Login or Register  to view this content.

Please Login or Register  to view this content.

@snb
That's the approach I most often use...it's clean and easy to use.

@Jaslake

You bet !

To comment a little on your suggestion

Please Login or Register  to view this content.

@snb
As always, I'm interested in your code suggestions...I believe you're brilliant (though often I can't read your code...my shortcoming...not yours). In this particular code

Please Login or Register  to view this content.

I actually have a folder called "snb Stuff". This image is stored there. I get this error message error msg.jpg at line

Please Login or Register  to view this content.

So, whats going on?

This should do the trick (option Base 0)

Please Login or Register  to view this content.

@snb

Almost works...sorts' not quite right...see attached. Click on Command Button.

Hello John,

Try this macro.

Please Login or Register  to view this content.

Example of Using the Macro

Please Login or Register  to view this content.

This is one way to alphebetize a ListBoxs list as it is being put into the list box.

Please Login or Register  to view this content.

Rather obvious:
For j = 0 To .ListCount - 2

Please Login or Register  to view this content.