Vba lookup

[CESAR V. ARROYO]

Hi there,

I am trying to develop a code that asks for a password, finds the matching name and prints the result in a certain cell. Vlookup does the job, but the other way around.

Actually I need to find the matching name to the left. I am attaching my workbook, and this is my code:

Please Login or Register  to view this content.

[royUK]

Use .Find in VBA,see


PASSWORD FORM4.zip

[foxguy]

Hi CESAR;

Don't know if you're still looking for an answer.
The thread isn't marked Solved, but I don't want to waste your time if you're satisfied with Roy's reply