sort an array

[bozic12]

Is there anyway in VBA to sort a populated array. I'm pulling data from a worksheet based on selected model numbers in a combobox that are controlled from a different worksheet. When I display the array in a list box, it's not in the same order as the first worksheet because it doesn't get "pulled" off the worksheet in the order it's listed. It will work if I sort both worksheets by the same two columns, but for recording reasons, I don't want to do that. I also know I could temporarily paste the array to a column on a worksheet, then sort it, then repopulate the array, but it would be easier if I could just sort it in the code. Thanks for any help!!

 

[mscallisto]

I'm sure you'll hear a better way from someone, but if not have you tried simple triangular or bubble sorts, etc?

 

[euskadi]

if you search the internet for "vba sort array" you'll come up with a million good answers to this one.... several different methods (including those suggested by mscallisto).

 

[bozic12]

mscallisto, i can't do a simple sort because i am sorting strings, bubble sorts and quick sorts only sort integers. euskadi, i did find some good sorting methods online, but it ended up that for what i was sorting, it was just easiest to paste it to a worksheet and use excel's sorting capabilities. thank you both though for your suggestions.

 

[RobBroekhuis]

I forget what quicksort is, but bubble sort (or even simpler, selection sort) works with any kind of data type for which you can use the < operator, or for which you can write a
function SmallerThan(item1,item2) as boolean

Still, sorting through Excel is easy enough, and does the trick.
Rob

 

[strongm]

>bubble sorts and quick sorts only sort integers

Huh?