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


Private Sub UserForm_Initialize()

'!!POPULATES THE LISTBOX WITH MANAGERS!!
Dim clist As Range
Dim ws As Worksheet
Set ws = Worksheets("allmanagers")

For Each clist In ws.Range("A:A")
  With Me.listMNGRREP
    If clist <> "" Then
    .AddItem clist.Value
    .List(.ListCount - 1, 1) = clist.Offset(0, 1).Value
    Else: End If
  End With
Next clist

End Sub