Need help with finding a value

[bill_s1416]

My workbook prompts the user for his/her password via a macro using InputBox.

password = InputBox("Please enter your password")

Once entered, I need a macro to find that password in the hidden "Roster" sheet of 200 users and return the user's name that is located in the next column over.

Please help.

[theDude]

Hi Bill,

Here's a macro that should work for you (it assumes that the User Name in the hidden sheet is one column to the right of the password):

Please Login or Register  to view this content.

Hope this helps,
theDude