Filter Data in userform ListBox

Hi There

I have been learning a lot of code since I started in this Forum, but I'm still quite newbie with ListBoxes. I have a clue already but I don't seem to understand the logic between the code to make things working. For that reason, I was wondering if you guys could help me with something. On my attached sample, all I need is this: text in "Sage code" Text box then listBox shows all the rows with column A matching. If I add "Part number ", it will show me all the rows with those 2 criteria and the third textbox the same. Finally, once button "pick 1" pressed, it will take 1 to the original quantity and update the cell automatically of the selected row. Is it possible/ Easy?


Many Thanks in advance

It is a start, Search, Pick 1, Delete Row, and exit without changes are working.


Kind regards
Leo

You could also filter in listbox.

Hi Leo

that is perfect for what I need, thanks. There is an error there is no match on the searchbox, but I can handle that, no worries. Thanks a lot for your quick and awesome reply.

Hi Bakerman/ PJ

it works lovely but for my purposes, I chose Leo's one. although, your solution will be used by me as well in other workbooks I have Thank you all for your help.

Thanks for the rep

Hi Leo

Apparently, I'm not being able to remove the error. My knowledge is still not enough. I have everything working already and there's nothing else I want to add. It is perfect for my needs. The only thing I would like is to remove this error (if there's no match on the textboxes, it gives me the 1004 error). what I would like is to simply show nothing if there's no match. I could survive with that but the problem is that more people will work with that form and they will be stuck if that happens.
Again, thanks for all your help.

Hi Tony,

now there will be a msgbox when there is no match
and delete row, deletes the row in listbox also


Kind regards
Leo

Thanks Leo. That is perfect Can't thank you enough!!!