Remove Item from Listbox by Item Name

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Randy - 19 Sep 2007 05:24 GMT

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

Reply to this Message

Doug Glancy - 19 Sep 2007 06:02 GMT

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

> 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
[quoted text clipped - 8 lines]
> Thanks,
> Randy

Reply to this Message

Randy - 19 Sep 2007 07:01 GMT

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

Reply to this Message

Doug Glancy - 19 Sep 2007 14:36 GMT

Randy,

I agree!

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

Reply to this Message