userform. search and display results from that row

hello, im setting up a materials workbook to help me be more efficient when quoting in the future

ive created two user forms, first to add materials which works great and the second to search materials and return all other info associated with the rows back into the remaining boxes. I chose to use combo boxes because they allow me to not know the full exact details and autofill. again the form im having issues with is the search one started from a command button on the worksheet

also seems like the comboox CB_Desc isn't adding to the sheet anymore for some reason
any help would be greatly appreciated

The attached should help to point you in the right direction, hopefully.

It wasn't adding the part description because you had the Bound Column property set to 3 instead of 1.

worked like a charm thank you very much