Listbox filled with data from combo box selection on a userform

I have a file that I would like to be able to see part number status when selecting a specific part number from a combo box. Would also like to be able to copy selected line of data in listbox when clicked to another worksheet but having no success at all doing this. New to VBA and cannot figure anything out. Appreciate any assistance in getting started. Attached a copy of file working with.

Thanks,

Kevin

Just a start,

selected item from listbox go to sheet 2

i made changes in named ranges, so those are dynamic now

for more, just give a sign

Cheers
Leo

Thanks Leo,

That works great but my issue with how do you configure the combo boxes to select a specific part number and status within those in the listbox.

Appreciate the assistance,

Kevin

So after the start, next part


kind regards
Leo

Hey Leo,

Thanks!!! That works great and exactly what I need.

Appreciate it immensely.

Kevin

Hey Leo, I just realized after using what you provided which works great I do not have the ability to add to the inventory table and be able to select new additions. Inventory table will continue to grow and have data added to it via another workbook. Is that possible with existing code or am I doing something wrong.

Thanks,

Kevin

Hoi Kevin,

i put new items from row 36 to 43 with new partnumbers and new status,
first check sheet1 to see the new items are not in the list,
after activate the userform and check again.


Kind regards
Leo