excel 2010 vba
I have a listbox on a userform
I'm filling the listbox via getrows method
What I need:
Specifically in column 13 in the listbox.
I may have values such as : "WD" "DV" "WV" "WG"
I want to press a command button and remove all the rows that have these value in
If no items exist in the listbox meeting this criteria then msbgox "No Items To Delete"
I have to keep pressing the command button until all are deleted doing this ?
Dim i As Long
For i = 0 To .ListCount - 1
If .List(i, 13) = "DG" Then
Exit For ' if i remove this line then my listcount gets messed up and i get errors