Re: Remove Item from Listbox by Item Name

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

"Randy" <spam.eastland@xxxxxxxxx> wrote in message news:1190175875.306337.82900@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
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


.

Relevant Pages