Sort an Array of items by Alpha

**realniceguy5000** · 07-05-2011, 11:00 AM

Hi,

I have the following script that collects my data into an array and adds to a combo-box, However the data is unsorted. I found a script that is suppose to sort the array, However I'm not having any luck with it. it may be the way I am calling it or something else I cant see at the moment.

I'm looking to either sort the array then add the items to the combo-box or Just sort the items that are placed in the combo-box. Or maybe someone has another Idea...

Can someone please take a look and advise.

Thanks as always, Mike

Please Login or Register  to view this content.

The Sort Script...

Please Login or Register  to view this content.

**snb** · 07-05-2011, 11:13 AM

Please Login or Register  to view this content.

**Domski** · 07-05-2011, 11:14 AM

Don't know if this is any use to you but it's something I use that's similar to what you are trying to achieve but using a collection rather than an array which has the advantage of only accepting unique items as well:

Please Login or Register  to view this content.

Dom

**snb** · 07-05-2011, 11:46 AM

or:

Please Login or Register  to view this content.

**realniceguy5000** · 07-05-2011, 01:06 PM

Ok, I gave both ways a try,

@ snb, I was not able to get your codes to work in my situation again I ran into the same problems I did with my sort script. I'm sure it's my fault as I just dont understand what it going on. As you say avoid code you dont understand... just my luck I guess. But thank you for your time...

@ Dom, I was able to get your option to work, Seems to work better anyway rather than to use an array of items. as I can sort then place the list right away.
Thank You for your time...

Mike,

**snb** · 07-05-2011, 04:08 PM

@RNG

I can't believe you did anything wrong

Please do what you would ask any OP: post your example workbook.

cfr. the attachment

**shg** · 07-05-2011, 04:31 PM

Mike,

Here's a 'black box' approach with an example. It does a simple insertion sort.

Please Login or Register  to view this content.

**realniceguy5000** · 07-07-2011, 04:59 PM

Thanks Shg...Nice Approach...

@ SNB....Thanks for the lesson.
I never said your code didn't work in fact you must be a master at taking 100 line scripts and making them 10 or less... lol I just dont understand your logic at times, which makes them harder for me to re-code if needed.
Maybe one day...

Thank You, Mike