Sort Array Alphabetically
Hello,
I am successfully able to sort through a range of cells and allocate names to various arrays based on specified criteria. Those arrays are then used to populate listboxes in a userform.
I am stuck on how to sort the array alphabetically before populating the listbox with the names.
Any help would be great...please see bottom of code below for populating listbox section
Please Login or Register to view this content.
why not sort on sheet, then put in array ?
If solved remember to mark Thread as solved
I figured that was also an option, but I thought it may be easier to do it directly in vb...can you please recommend the code for that process?
Have a look here http://www.excelforum.com/excel-prog...95#post2954995
Hello gsurge,
This macro will sort a list in either ascending (A-Z) or descending (Z-A) order. The default is ascending. The list can be either 1-D or 2-D single column.
Please Login or Register to view this content.
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
try this
Please Login or Register to view this content.
Thanks,
Mike
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
as an option
Please Login or Register to view this content.Please Login or Register to view this content.
Thanks Leith. I placed your code in a module and called it using:
But this didn't sort the array...did I miss a step?Please Login or Register to view this content.
Nilem,
That worked perfectly! Thank you so much!
One quick thing...I still have a space at the beginning of my array...apparently I didn't remove it. Any idea on how to get rid of this?
Hello gsurge,
The macro is a Function that returns the original array as a sorted array.
Please Login or Register to view this content.
change this lineOriginally Posted by gsurge
Please Login or Register to view this content.
thank you again. everything works perfectly.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks