Help: Search data in worksheet and display the data in userform text boxes

I have an excel workbook containing 3 sheets. In sheet 1, I have a table (Part Number, Description, Price). I have created a userform and want to have a search option in it. Whenever I enter the part number (Full or partial) and press search button in userform, the data should be searched in sheet 1 and search results should be displayed in textboxes in userform. Here is my form layout:


FormLayout.jpg

Here is my Code:

Please Login or Register  to view this content.

The above CODE works only if I explicitly mention the part number (Eg: "2502" or "3306") in find(What:= ) of find command.

1. Where Am I going wrong ?
2. I want to retain the formatting as in sheet1
3. Why Am I getting no search results for code 1 ?


Thanks and Awaiting help !!

Moderator Note:

Pls use code tags around your code next time as per forum rules.