VBA Userform to search Excel used as database

Hi Guys

I am using excel as a database and I have created a userform that amongst other things searches a worksheet on button click. The problem I am encountering is that when I search, the search goes row by row, namely if the data being searched for is on row 3 in the worksheet, it first displays a "Not found" message for rows one and two and upon cancelling it moves to the next until it finds the entry. Is there a modification I can make so that the search goes smoothly, that is despite the row number if data is present it is immediately displayed without first showing a couple of "Not found" messages? PLEASE HELP!!! Below is my code for button click:

Please Login or Register  to view this content.

Code Tags Added
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found at http://www.excelforum.com/forum-rule...rum-rules.html



(Because you are new to the forum, I have added them for you today. Please take a few minutes to read all Forum Rules and comply in the future.)

Try removing or commenting out these lines of code

Please Login or Register  to view this content.

Post example file with Userform and dummy data so your code can be rewrittin to suit your needs.
Try this for starters.

Please Login or Register  to view this content.