Deleting a selected Item from a ListFillRange

[stirlingmw1]

Afternoon all.

I am trying different ways to achieve a certain goal and hope you can help.

I have a worksheet that I select an "Item" from a Data Validation List in cell B3 of my worksheet "Uplift", I then add a "Qty" in cell "D3", on Selecting "Add" (Button with Macro) the Item and Qty are added to worksheet "Selected" column B and C, these then become part of a dynamic list i am using as a ListFillRange for a ListBox1 on the "Uplift" worksheet, I can do this multiple times, each time adding an item and its qty to the next available row within the worksheet "Selected" at the same time updating the ListFillRange.

My question is,

How would I code a macro to remove a selected Item and its Qty I have selected from within the ListBox1 which then is in turn deleted from the "Selected" worksheet?

Thanks

Steve

 

[bobsan42]

use the .Listindex of the selected item to locate it in the range on the "Selected" sheet delete the corresponding row from the sheet then update the listbox.