Hi there,
After populating a listbox with 3 column of data, I would like to remove all the items from the listbox. I tried the following codes without success :
Sub ClearAll() ListBox1.RemoveAllItems End SubThe latter code seems to work on a single column listbox only. Would someone come up with a code to clear the listbox? Thanks in advance.Sub ClearListBox() Dim i As Integer For i = 1 To ListBox1.ListCount ListBox1.RemoveItem 0 Next i End Sub
Regards
KP