Good Afternoon,

I'm hoping you can help. I have a user form which has the entries, First name, Last name and Job Title. I'd like the Job title to be filled in from my "Starters" tab as the data is already in there.

this is the code I'm currently using.

Private Sub TextBox1_AfterUpdate()
With Me
.TextBox2 = Application.WorksheetFunction.Index(CLng(Me(.TextBox1)(Sheets("Starters").Range("D3:D2000"), Application.WorksheetFunction.Match(Sheets("Overview").Range("A77") & ("B77"), Application.WorksheetFunction.Index(Sheets("Starters").Range("U3:U2000") & ("V3:V2000"), 0), 0))))

End Sub
When I input the data into Textbox1 (this is First name) and the data into Texbox2 (Surname) then I'd like Textbox3 (Job Title) to autofill from the Starters tab.

Please help?

Thanks!