Userform search not displaying data

Really struggling to understand why my userform is not displaying the data (Admin tab) into the relevant text box.

When I click the search button on the userform it just does nothing.

The IF empty code seems to work though, which is strange...

This is the code I have used and a sample document is attached. Help is really appreciated!

Please Login or Register  to view this content.

Thank you in advance!!

Originally Posted by Richard Buttrey

Hi,

You have an Exit Sub immediately after your first If..End If block

and unless the characters in the text box are EXACTLY the same cse as in column C you will miss finding a macth. It's always preferable to convert both sides of an if testto either Uper or Lower case. e.g.

Please Login or Register  to view this content.

Richard,

That's an awesome shout, thank you. I hadn't thought of the lower case until you mentioned it - tested and works great!

Very silly of me to place the Exit Sub there. My reasoning for this was to prevent the msgBox popping up after the user tries to search with a blank field.

Are you able to help with that?

So I movied the Exit Sub before the End If and that looks to have done the job!

I was getting double message boxes. The second was from the next line of code