login credential in userform

[xlhelp7]

Hello everyone!

Need your expert help!

I have created a userform in this userform i require a login credential. In login ID sheet in column A i have login passwords and in column B i have Evaluator Names. Actually what i want when i click macro
it should ask for the password and if i enter correct password which are in column A in login ID sheet then it should proceed further otherwise a message should prompt Access is denied, Enter correct password.
At the same time when i enter correct password then Evaluator name from column B from Login ID sheet should copy and paste in userform in Evaluator Box like if i select password 12618 then Evaluator Name from column B
Pratibha Sharma should copy and paste in userform in Evaluator Box.

Regards,

Xlhelp7

[xlhelp7]

Any Help!

Regards,

xlhelp7

[xlhelp7]

Hi,

I have used below code to protect userform with password but this code is for single password if i use multiple password then its not working.

My code

Dim strPasswd
strPasswd = InputBox("Enter Password", "Restricted Form")
If strPasswd = "" Or strPasswd <> "12618" Or strPasswd = Empty Then
MsgBox "Access is Denied", vbInformation, "Required Data"
Exit Sub
End If
If strPasswd = "12618" Then
End If

Please help!

[spitfireblue]

Hi,

Please use code tags in future.
Without going away from what you have already done try this:

Please Login or Register  to view this content.

[spitfireblue]

Here is another way to do it:

Please Login or Register  to view this content.

[xlhelp7]

Hi Stephen,

will take care code tags in future.

Thanks for your wonderful help!

My issue is resolved by your code!

Regards,

Xlhelp7