Sorting array on the basis of Length of element

[ImranBhatti]

Hi,

One combobox is populated from an array of string

Please Login or Register  to view this content.

And ItemList is the list of unique items taken from an ongoing column

("Itemmmm,Itemm,Itemmm,Item")

Need it to be
("Item,Itemm,Itemmm,Itemmmm")

Can't sort it on the sheet

I am getting the unique list from D column with a dictionary way.

Thanks in advance

[jason.b75]

Your example implies that you just need to reverse the list, if you can't sort the original list, how about another column to sort it, then populate the combobox from the new column?

=INDEX(ItemList,ROWS(ItemList)-ROWS(A$1:A1)+1)

[Fluff13]

How about

Please Login or Register  to view this content.

[mikerickson]

Or you could sort it (by length) after it is filled

Please Login or Register  to view this content.

[ImranBhatti]

@jason thanks but I don't want to reverse the list, I want to sort the Combobox items in place. Your solution did contributed to one of my older threads here.


@Fluff Thanks your solution is working as required.

@mike Thanks for your solution too, but I have a combobox on the userform and not listbox. Secondly how should I pass this?

[Fluff13]

You're welcome & thanks for the feedback

[mikerickson]

@mike Thanks for your solution too, but I have a combobox on the userform and not listbox. Secondly how should I pass this?

ComboBox and list boxes are almost identical, other than changing to AList box to type MSForms.ComboBox1, nothing more is needed.

[ImranBhatti]

Thanks mike I did changed but I mean how should I pass the parameters

Me.ComboBox1.list = ?

Me.ComboBox1.List = SortLBbyLength(Me.CombBox1.List)? or something else?

[nigelog]

I used it like this and worked ok

Please Login or Register  to view this content.

[mikerickson]

Thanks mike I did changed but I mean how should I pass the parameters

Me.ComboBox1.list = ?

Me.ComboBox1.List = SortLBbyLength(Me.CombBox1.List)? or something else?

Fill Combobox1 and then call the Sub

Please Login or Register  to view this content.