VBA to find a value in a list
Tom,
Thanks for your "other" reply, so quickly. Yeah, I had to leave for a
meeting and it was essential that I have a solution upon returning, so I
thought I'd pursue a couple of different avenues.
"Tom Ogilvy" wrote:
Getting enough answers?
--
Regards,
Tom Ogilvy
"Bill_S" wrote in message
...
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.
|