Sorting Listbox

[yawnzzzz]

Hi,

I have a listbox that's populated from a range using rowsource. It also is set-up to display column headers. What I'd like to do is make it when a user clicks on the column header, it sorts based on which column was clicked. Is this possible?

Currently, I've created buttons for each column heading, so the user can click the corresponding button to make the listbox sort by that data, but almost every program out there allows a user to click on the header to do this, so I'm wondering if it's even possible.

Thanks!

[mikerickson]

I like to use the double click event for this kind of sort. Put this in the sheet's code module, double click on a cell and the data will be sorted on that column.

Please Login or Register  to view this content.

[dan2010]

is this for excel 2007?for headers of listbox or the sheet?
i tried the code but nothing happened when i click on my headers(for listbox) :S
btw i am using listbox from activex, 01-fmmultiselectmulti