I found a code that sorts a userform listbox alphabetically.
Was wondering if there is a way to first sort all the selections alphabetically witht he first selections at be displayed at the top of the list box and then all the unselected items (already in alphabetical order) to be displed below all the selections?
I know i'm way off but i tried the best i could, see below:
I really would appreciate any help on this.
Please Login or Register to view this content.
i was thinking that maybe the code can achieve the same goal by removing the selected item from the list box and then adding it to the top of the list box like this:
remove:Please Login or Register to view this content.add:as the "0" adds the item to the top of the list.Please Login or Register to view this content.
One of the problems i am having is that "Bitem" is not a string but rather a number. And the other problem is...i have no clue what i am doing
Once again i am seeking some guidance.
You should extract the selected items to an array, sort what's left, sort the extracted array and add the extracted items back at the top using AddItem.
As for sorting numerically you'll need to convert the values to numbers when comparing.
That's the theory anyway, can't post any code right now, not at a computer.
If posting code please use code tags, see here.
Maybe something like this:
1. assign selected item value to a variable (k)
2. change selected item value to 0 (so it will be on top when sorted)
3. sorting
4. change listindex(0) value to k
Please Login or Register to view this content.
Hi Akuini and Norie,Originally Posted by Akuini
Thank you Akuini for your code and thanks Norie for the idea which i started working on but looks like a it's a long road for me.
In Akuini's code i changed a couple things like removing the zero which won't get removed by the code. I also had the code re-select the item that was sorted to the top since it got un-selected.
I'm having trouble though when applying your code to a multi-select list-box, code works fine when the list-box is limited to one selection.
Also, i inserted this bit to re-sort the items when a different selection is made in the combo-box:
and this bit to deselect the previously selected items:Please Login or Register to view this content.
, however, (and i think this may be what Norie was touching on) the items are mixed up internally. Meaning, even though the items are displayed properly they are not selected properly by the code anymore.Please Login or Register to view this content.
See attached workbook (the code will debug since the listbox is set to multi-select, if you change it to single select the code should run but it won't run properly)
Last edited by kosherboy; 04-19-2016 at 01:41 PM.
I made an example regarding how to sort listbox with multi select options.
I use 'System.Collections.ArrayList' object to populate the list because this object has 'built in' sort function.
This is how it work:
1. user pick an item in combobox. It will sort the listbox and clear selection.
2. user pick some item in listbox
3. hit the command button
4. the selected item will be on top & the list below it is sorted.
This the workbook:Please Login or Register to view this content.
https://www.dropbox.com/s/ttm0pqmtcd...list.xlsm?dl=0
Amazing show! You sure know how to code!
I'm speechless.
Thank you for your time on this and keep in mind that i appreciate your knowledge very much
You're welcome & thanks for your kind word.Amazing show! You sure know how to code!
I'm speechless.
Thank you for your time on this and keep in mind that i appreciate your knowledge very much
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks