I have the following code that poulates a list box on a form
How can I sort the list based on the values in the third column in the list box (column D)With lstAcc ReDim aryItems(1 To iLastRow) For i = 2 To iLastRow If Cells(i, "A").Value = idx Then .AddItem Cells(i, "B").Value .List(.ListCount - 1, 1) = Cells(i, "C") .List(.ListCount - 1, 2) = Cells(i, "D") End If Next i End With
Column D will be sequence number