Selecting Row in ListBox and editing cell values

[tony75]

Hi Guys
I'm afraid I need your expertise once again. I am a virtual Zero when it comes to ListBoxes. I have a small userform which displays on a listbox all valid results. That part I was able to do. What I'm trying to achieve is to select a specific row in the listbox, add a number in TextBox2 and then It will remove from the quantity in column 5 which will change the cell value as well and finally refreshing the list with the new result?
I looked everywhere and I almost did it but after 3 days, I decided I don't have enough skills.
Thanks for your help, as usual.

[maniacb]

Can you provide a results page with what you expect, like walk us through an example?

[tony75]

Sure. In the Userform, if I type "1042." in textbox1, it will add by vba "XXX" wich the code will search all rows in sheet "SPARES", Column A, all matches of "1042.XXX". In this Case. in the listbox, it will be displayed Rows 8, 9 and 12. Let's say I want to take a certain quantity from the row I select In the listbox, row 8 for example. In the SPARES sheet, Column D, it has 75. My goal is to type "5" in textbox2 and once I click "TAKE THE QTY ABOVE" button, it will remove those 5 out of the 75 in total, updating the cell to 70 and displaying the new result in the listbox. please let me know if that is clear enough?
Thanks

[torachan]

See if the attached satisfies.
I have replaced the textbox with a combobox - this loaded with filtered one of each initial type.
selection of type then loads the listbox with all items in group.
because the listbox filtered group loses its sheet row reference this has to be re-established by a small search routine.
any queries post back on this site
torachan

[tony75]

It works perfectly, thanks torachan
The only thing not working is the image load, but I'm sure I can figure out a way.
Thank you once again!