VBA sorting by multiple criteria help needed

VBA in Excel, Office 2010

So my creation algorithm creates an array of objects of possible combinations, copies the values to an excel spreadsheet, sorts the spreadsheet by 8 different criteria, then outputs the ordered list to a listbox for the user to select. The user selects which item they want, and then moves on.

Unfortunately (and I have noone to blame for this but myself) I used a lot of cheap shortcuts like that to quicken the coding process. Now that there's some talk of moving my application from out of excel, I've been trying to streamline/optimize my code so that when I go to another language, the coding will be fairly similar in whatever language it gets written in.

My program works currently because I have the crutch of the excel spreadsheet to re-select my data once selection occurs. I would like to rewrite my code so that the sorting is done within the actual object array, so that when the user selects something on the listbox, I can just use the index selected from the listbox to then choose the correct object to move on, without using any inbuilt excel functions. All the items I have to sort would be done by either numerical or alphabetical.

You may find Chip Pearson's Sorting Array In VBA article helpful.

Also consider that the application or Code Language you port to may have better built-in array sorting tools than VBA offers.

Thanks! This is what I needed.