Remove Item from Listbox by Item Name

  • Thread starter Thread starter Randy
  • Start date Start date
R

Randy

This one has to be really easy, but I can't track it down. I know how
to remove an item from a listbox using its index value, but how do I
remove it by directly referring to the name of the item? Example:

lbx1.RemoveItem ("DeleteThis")

This line errors out as an invalid argument.

Please help.

Thanks,
Randy
 
Randy,

You have to loop through the list items. If you had a CommandButton1 on
your form, this sub would remove an item called "Doug":

Private Sub CommandButton1_Click()
Dim i As Long
For i = 0 To Me.ListBox1.ListCount - 1
If Me.ListBox1.List(i) = "Doug" Then
Me.ListBox1.RemoveItem (i)
Exit Sub
End If
Next i
End Sub

In some situations it makes sense to clear the list, e.g.,
Me.ListBox1.Clear, and then repopulate the Listbox.

hth,

Doug
 
I know how do that easily enough. It just seems like a lot of
unnecessary lines to process, but oh well.

Thanks for your help.
Randy
 
Back
Top