Converting listbox code to work with Listview

Hello,

I am new at VBA and I have just discovered the listview control. I would like to convert my listboxes to listview control to allow for sorting, columns, etc.

I have the following code written to populate my three column listbox. Can someone please help me convert this to populate the listview?? I would also love to get some help on identifying the header names and sorting by clicking on the column header

THANKS!!

g

Please Login or Register  to view this content.

I actually will be distributing my form to a large audience. Thank you for the heads up.

Can you help me with a code that will identify column headers from my workbook range in my listbox and allow the user to sort by clicking on the header? That is really all I wanted from the listview control.

Thanks!!

a listbox on a userform. I would like to populate it with the excel sheet range using the code posted above. I just need to add another column and allow for sorting (with headers)...thats where I am stuck