Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete selected Item from listbox
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete selected Item from listbox
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" wrote in message ... 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. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Delete selected Item from listbox
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" wrote in message ... 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to get the index in VBA of the selected item in a ListBox | Excel Programming | |||
Need selected item from listbox after double click | Excel Programming | |||
How to copy selected listbox item to sheet | Excel Programming | |||
Listbox - write newly selected item back to the worksheet | Excel Programming | |||
Count number of selected item in Listbox | Excel Programming |