Hi all,
I have a multicolumn listbox in a userform that has 5 columns. As my dataset is growing, I need to allow users to sort the columns using command buttons placed above each column. I have found examples of how to sort 1 or 2 columns, but cannot find anything for 5 columns.
The following is what I have used for a 2-column sort, and am curious if it can be modified to be used for a 5-colum sort.
Please Login or Register to view this content.
This will do it for any number of columns.
Please Login or Register to view this content.
Thank you, Andy. I appreciate your response.
Does this now allow me to specify which column to sort by? At first glance, to my amateur eyes, it appears not.
The other part of the challenge I face is the ability to specify the column to be sorted, and have a command button above each column to allow users to sort by those columns, respectively.
-Dave
Yes it does. That is what the SortOn argument in the subs signature is.
This example will sort the column you double click.
Wow, Impressive! Thank you so much for the file with a working sample. Implementing this will with my application will be fun.
That was Great! Thank you so much!
Thank you for this code. This is really great.
But I'm actually looking for a similar code to use in a listbox in Word in which I've loaded an Excel database.
Can you help me out here, please?
Thanks
Kem
Kem60,
Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.
If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.
Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.
Ben Van Johnson
Hello Andy,
I was looking for a code to sort a multicolumn list box and i came across your double click feature which is really impressive!
So i implemented my excel case into your double click idea but i noticed that the column that has dates doesn't get sorted properly.
I uploaded a sample of my work.
Please note that my userform-initialize to populate the list box is constructed differently than yours.
Thanks!
I think the issue lies when i loop through rows, not just the dates.
Just wanted to clarify.
The sort is a bubble sort based on the textual content. In order to sort the dates properly you will need to sort their numeric values rather than the text in m/d/yyyy format.
I have added a extra column, which you can hide using ColumnWidth of zero. When the 2nd column is sorted it uses the extra column values to actually sort on.
first off all very nice work-a-round ideaOriginally Posted by Andy Pope
i am learning userforms by looking at examples and solutions
in looking at this example 964420 i not that allthough it does everything OP required. for me it does not display the first row of your data sheet in the userform
maybe i am doing something wrong
regards
◄Ŧя?μвŁ?►
By Name & By Nature
Hi Andy,
That's a very creative solution to the date issue, never would have come up with that on my own
Thanks!
Best,
KB
@AkaTrouble. In order to display header in a listbox you need to use the rowsource property. This links the listbox directly with cells on the worksheet with the header row being the row immediately above the data. In order to sort the listbox you will need to sort the worksheet.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks