Help in Userform..!!

[Rahul Aggarwal]

Hello Team,

I have created a userform for login and password. below is the my code:

Private Sub CommandButton1_Click()
Dim username, Password As String

username = TextBox1.Text
Password = TextBox2.Text

If username = "myuser" And Password = "mypassword" Then
MsgBox "You entered the correct information", vbInformation
Unload Me 'unload this form

Else
MsgBox "You entered the wrong information", vbCritical
'now close the workbook
ActiveWorkbook.Close

End If
End Sub


I want different password for different username. for example if username is "Rahul" then password should be "Rahul" and if username is "Raghu" then password should be "Raghu"

Please help me how i can modify this coding to get desire result.
Your Response will greatly appreciate.

 

[Abhijeet R. Joshi]

Hi Rahul,
Welcome onboard..

As a new user I think you should have a look at
http://chandoo.org/forum/threads/new-users-please-read.294/

Regarding your question:
If you want the username and the password to be the same you use a similat if code there:
if username=password then true else false..something like that...

 

[Rahul Aggarwal]

didnt get u buddy, could u please paste me the code after modification

 

[Abhijeet R. Joshi]

Private Sub CommandButton1_Click()
Dim username, Password As String
username = UserForm1.TextBox1.Text 'code amended
Password = UserForm1.TextBox2.Text 'code amended
If myuser = mypassword Then 'code amended
MsgBox "You entered the correct information", vbInformation
Unload Me 'unload this form
Else
MsgBox "You entered the wrong information", vbCritical
'now close the workbook
ActiveWorkbook.Close
End If
End Sub

 

[SirJB7]

Hi, Rahul Aggarwal!

If I don't understand wrong you want a list of user IDs and passwords, so you first has to build a 2 dimension array like:
Dim sUIDPwd(10, 2) as String
where you'll store in the 1st column the user ID and in the 2nd column the password. You could hardcode (not recommended) it within your code or you can load it from a range at any worksheet (in this case it'd be desirable to protect the worksheet and scramble the contents and... a lots of ands).

But regarding your comment about:

I want different password for different username. for example if username is "Rahul" then password should be "Rahul" and if username is "Raghu" then password should be "Raghu"

do you really mean that user ID and password are equal??? Besides insane it's a nonsense, IMHO.

Regards!

 

[SirJB7]

Crossposted at: http://chandoo.org/forum/threads/my-filesss.13962/
Please keep all questions on same subject within same thread.