Sorting Listbox & Delete

[calvinle]

Hi guys,

Here I have a listbox, but I would like to know if it's possible to be able to sort each header on the userform when clicking on the header?

Also, how should I also delete some entries with a button?

Please help.

listbox.xlsm

[patel45]

You need listview, see attached file

[calvinle]

But how do I delete with a button?

[lapot]

This is a very useful listbox ,can anyone help please?

[Fotis1991]

This is a very useful listbox ,can anyone help please?

Hi

What kind of help?

I suggest you to start a new(your own) thread with your question and if you feel that this thread is relative, then add a link to this thread.

[lapot]

sorry I didn't know that

[patel45]

But how do I delete with a button?

you can delete BEFORE SORTING with this code, see above attached file

Please Login or Register  to view this content.

[calvinle]

Hi Patel,

Thank you very much for the code. I am getting almost there. The delete option that you gave can only delete 1 at a time. How to do so if multiple select is set to true. How to multi select delete rows??

[patel45]

Please Login or Register  to view this content.

[calvinle]

Perfect!!!! You are incredible! Thank you so much!

[calvinle]

I did not see the before sorting part. Will it be possible to also if we sort them, it will sort in the sheet as well?

Thanks.

[patel45]

Please Login or Register  to view this content.

[calvinle]

You are the best!!! I am pretty sure this topic will help a lot of people in here..!

Thank you!

[calvinle]

Do you have any suggestion if I want those listview cell to be editable?

Thanks.

[patel45]

I think you have to open a new thread