Okay, i have been trying to figure this out and i am stuck. I have a userform
that uses textbox1.value to find an item in a table. From there the values of
the table populate a listbox using .list(.listcount -1,0)= ....etc.. Anyway
what i would like to have happen is when the user Dbl Click the selected item
in the listbox it clears that item from the list box and leaves the data on
the table. Thanks.

Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
With Me.ListBox1

.RemoveItem (.ListIndex)
End With
End Sub

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Office_Novice" <(E-Mail Removed)> wrote in message
news:E28661A1-1204-4345-A472-(E-Mail Removed)...
> Okay, i have been trying to figure this out and i am stuck. I have a
> userform
> that uses textbox1.value to find an item in a table. From there the values
> of
> the table populate a listbox using .list(.listcount -1,0)= ....etc..
> Anyway
> what i would like to have happen is when the user Dbl Click the selected
> item
> in the listbox it clears that item from the list box and leaves the data
> on
> the table. Thanks.

Thanks, Bob i new it was somthing easy. Just too early for me.

"Bob Phillips" wrote:

> Private Sub ListBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
> With Me.ListBox1
>
> .RemoveItem (.ListIndex)
> End With
> End Sub
>
> --
> HTH
>
> Bob
>
> (there's no email, no snail mail, but somewhere should be gmail in my addy)
>
> "Office_Novice" <(E-Mail Removed)> wrote in message
> news:E28661A1-1204-4345-A472-(E-Mail Removed)...
> > Okay, i have been trying to figure this out and i am stuck. I have a
> > userform
> > that uses textbox1.value to find an item in a table. From there the values
> > of
> > the table populate a listbox using .list(.listcount -1,0)= ....etc..
> > Anyway
> > what i would like to have happen is when the user Dbl Click the selected
> > item
> > in the listbox it clears that item from the list box and leaves the data
> > on
> > the table. Thanks.
>
>
>