Userform that looks up up data from main worksheet

[danbates]

Hi,

Please would someone help me?

I copied a Userform textbox search form off youtube and it worked fine for the first few days. Now though its not working.

When I enter a process number in the textbox and press enter it just comes up with my message that is there to warn the user if the process number is wrong or has been inputted incorrectly.

Please could someone take a look at the "Search" code and tell me whats gone wrong with it.

The "Clear" and "Close" buttons still work correctly.

Any help would be much appreciated.

Kind Regards
Dan

[:) Sixthsense :)]

Replace your current CommandButton1_Click code with the below one

Please Login or Register  to view this content.

[danbates]

Hi SixthSense,

your code has worked perfectly, Thank you.

Kind Regards

Dan