UserForm Auto populating data from a worksheet

Hi Guys,

I've done a little research and I can't seem to find anythign that helps. Here's the situation:

I have 7 textboxes (TextBox1 - TextBox7), I also have a hidden sheet that has a nominal roll of shorts with 7 columns worth of pers data.

What I would like to happen is when the member's employee number is typed into the userform, it auto populates the other 6 textboxes from the worksheet with the pers data.

This is the code I have so far for what I want it to do besides the above:

Please Login or Register  to view this content.

Hi Robert! (Completely agree with the name btw!)

Fantastic bit of code, trying to reverse engineer it so I can learn it! Thank you so much! If I could ask, how could I ammend this to automate the process once you tab or click out of the textbox?

Cheers,

Rob.

There will be 800 + entries with the addition of another userform designed to add entries.

How would the Event macro look?

Cheers,

Rob.

I'll have a play around with both and see how it feels!

Thanks again for your help. I'm having issues with the website, when I get home I'll add to your rep!

Appreciate it!

Rob.