DISPLAY MULTIPLE SEARCH RESULT IN A LISTBOX WITH EXTRACT TO EXCEL OPTION

[jhazziejhazz]

Hello everyone,

How can I display the search result in this listbox.

Example I want to search for a particular "Part Number" and I want all the records to display in the list box. The idea is for every Part Number there will be several transaction/movement, and I want them all to be displayed in the listbox when I click the search button

(Please see attached image)

Thank you in advance for those who will take time to answer my questions,



Jhazzie

 

[Akuini]

Hi, @jhazziejhazz
Maybe this could help:

Filtering a 2D array in a listbox from a textbox

Hi everyone. I have a userform with a textbox and a listbox. The listbox is populated with data from a 2-column ListObject table whenever the form initializes and, as I type in the textbox, it gets filtered using the full string. That works, but since I'm filtering construction materials, I...

www.mrexcel.com

 

[jhazziejhazz]

Hi, @jhazziejhazz
Maybe this could help:

Filtering a 2D array in a listbox from a textbox

Hi everyone. I have a userform with a textbox and a listbox. The listbox is populated with data from a 2-column ListObject table whenever the form initializes and, as I type in the textbox, it gets filtered using the full string. That works, but since I'm filtering construction materials, I...

www.mrexcel.com

Thank you for your reply @Akuini, however my knowledge on excel vba is so limited that I am having a hard time understanding the flow of the codes.
Honestly, I have done this from scratch only from watching vids on yt and copying some of the codes and apply it to my project.

By the way heres the link to my sample file jsut incase you wanna check it out to fully understand my question
SAMPLE.xlsm

Thank you so much for taking time to answer my question.

Jhazzie