Populating a userform from a search button and editing the workbook

Hi all
I am new to Excel programming so please forgive my ignorance. I have a spreadsheet with about 20 columns that are updated daily. I have been tasked with creating a userform that can be used to call a record from the dispatch sheet by either WO number, Product Number. The record needs to display 8 cells from the line chosen.
I got a lot of the code and ideas from different forums including this one. The issue is I can’t get it to work correctly. First issue is when I hit the search button, the Documents folder. Second it returns the row number instead of the contents of the WO cell. Next the cells that have the contents of a VLookup don’t display along with the cells past the 10th column. I have attached the file in question.
Any help or direction would be great.
FF1 SSN dispatch New v1 - Copy.xlsm

JasLake
I apologize for the wording in my post (it was late) but when I wrote “the Documents folder.” I meant to say the Documents folder from my computer opens.
As I said I got a lot of the code from the net, so the Results Worksheet is not something I want and was going to remove but when I did the rest of the form would not work correctly.
I made the changes you suggested and I got the error “Run-Time error '380': Could not set ListIndex property. Invalid property value.” I think I put it where you said but I am sure that I did something wrong. I will attach the file with the changes. It is the user form that all the information is supposed to be displayed in and edited from.
The intent of the user form is so a person can search 100’s of records by entering a WO or a Product Number and then enter or append the comments.
I do thank you for the help
FF1 SSN dispatch New v1 - Copy.xlsm

Jaslake

You have been a great help. And the questions that I had, have been solved. The excel.com site can’t help me.