I have this inventory tracker excel file, that has use form for my search function (see attached image)
I have a combo box for search option, the result will display in 2 separate listbox one is the AVAILABLE STOCK and the other one is SEARCH RESULT - PRODUCT MOVEMENT.
I have this 3rd list box, in which I wanted to have the values when I click 1 of the result from listbox in Search Result - Product Movement. Values for these list box will come a different sheet (RRBS_List)
Example, When I search for a particular Part Number, results on Search Result - Product Movement will display, and when I click one of the result, the values will populates the third listbox.
I hope I made my explanation clear.
Thanks in advance for those who will take time to answer this queries.
I have attached my sample project. This has been a work in progress.