How can I use a vlookup in a UserForm

[bradfordahill]

I have created the attached UserForm and I am now attempting to use a Vlookup or VBA code to make filling the form out easier.

Basically, when the Manager inputs the employees name, I would like it to auto populate the supervisor and employee ID number.

The above information is currently housed on the Reference Page. I have watched videos, tutorials and researched the web but still can not figure out how to make this happen.

Please overlook the "REF" column as that was supposed to attach a # to the row but I am going to do something different.

Thank you in advance for the assistance.

[AlphaFrog]

The Name combobox is populated from range A2:A144. When you select a name,it has an index number. The first name in the combobox list is index number 0, the second name is index 1, the third name index 2...etc. You can use the index number of the selected Name as the row number by adding 2 to it. So the first name is index 0. The add 2 to it and you know it is from row 2. Make sense?

The code below gets the index number of the selected name, adds 2 to it and gets the values from that row from columns B and C for the respective ID and Supervisor.

Please Login or Register  to view this content.

[bradfordahill]

OMG you are freaking awesome.

Thank You - Now I will have to review and understand your code.

[bradfordahill]

So, when I applied the above code, the UserForm stopped looking for next blank row and is just replacing the data in the same row. Where/What am I missing?

[AlphaFrog]

The code I suggested doesn't look for the next blank row or replace anything. I don't know what you're referring to.

[bradfordahill]

Yea me either apparently. I must have deleted something unaware. I downloaded the version uploaded here, applied your code and it is working correctly. FAT FINGER TUESDAY apparently. Sorry