Userform listbox sort columns by clicking on header

Hi,

I have posted this same question on Microsoft's Q&A, but not getting any response, could be the wrong place to ask, so asking here as well.

https://docs.microsoft.com/en-us/ans...-on-heade.html

In Excel vba, I have a listbox in a Userform and would like to sort the column when a column header is clicked. Is this possible?
So, if I click on column 6 header then it will arrange all the columns by column 6 alphabetically, and then if I clicked column 6 again then it would reverse the order.

126086-image.png

Thanks
ST

Thanks very much Torachan, that's given me an idea to work on