Removing items from listbox

[jharaldson]

I have a listbox on an userform and it is populated from a range on a worksheet. I want to double click on selected item in my listbox to remove the item from the listbox and from the range.

Thanks

[MaczaQ]

hi,

You didn't attach any sample workbook so I will show You my idea.
Let's say your source for listbox1.list is in the range of sheet1 A1:A5.
List will be automaticaly load on userform initialize

2 procedures for userform

Please Login or Register  to view this content.

and it is what You need I think

[jharaldson]

Sorry MaczaQ,

Here is a sample book. I need it to delete the whole row.

[jharaldson]

Sorry old workbook, this one is updated.

[jharaldson]

I added this to your code,

Please Login or Register  to view this content.

and that clears the row but now I want it to show on the sheet right away, not when I close the form. Is that possible?

[MaczaQ]

hi jharaklson,

Sorry I've changed a bit Your code, below You will find an update; old lines I hash.
For now that code get an array as listbox source from range (without any loop) and delete whole row when You will double click on listbox item

Please Login or Register  to view this content.

[jharaldson]

thanks for your help macza!