View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill_S Bill_S is offline
external usenet poster
 
Posts: 30
Default 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.