VBA Excel UserForm User and password LogIn

i have a problem with user and password login i have form and registration form
in registration all information that fillup in register form we will save in sheet1 like this!
[Blocked Image: http://i1287.photobucket.com/albums/a639/Mac_Baculanlan/asdasd_zpsd3269bcf.png]
and in login form if my name and password does not match of any in sheet1 rowA for name and RowI for pass data msgbox("Name or password does not match")
and if the password or name is match in sheet the loginform lunch another form and success login?
it just like multiple user login but i don't know how to do it i'm noob newbie xD
[Blocked Image: http://i1287.photobucket.com/albums/a639/Mac_Baculanlan/sda_zpsfe5c02b8.png]

Name = tbName
Password = tbPassword
thnks!!
Sorry for my bad english

Re: VBA Excel UserForm User and password LogIn

hello sir royUK your password form v6 have problem xD i think have virus cuzz may kaspersky send me it will harm to my computer and i can't open macro and any lolhello si holycow ok here's my file xD i want only simple

Re: VBA Excel UserForm User and password LogIn

Quote from holycow;681272

Hi mackuletz

I think you will have better chance of someone helping you if you upload your workbook. You can remove any confidential information. Hopefully someone will help you soon. If noone jumps in I will have a look in a few hours.

forum.ozgrid.com/index.php?attachment/55964/
here xD if i use if else and elseif statement i have problem for example

[/B][/COLOR]Private Sub CommandButton1_Click()Dim x, z As IntegerIf TextBox1.Text = Sheet1.Range("B1").Value And TextBox2.Text = Sheet1.Range("B2") Thenz = MsgBox("Login Success", vbOKOnly, "SUCCESS")UserForm1.HideUserForm3.ShowElseIf TextBox1.Text = Sheet1.Range("B3").Value And TextBox2.Text = Sheet1.Range("B4") Thenz = MsgBox("Login Success", vbOKOnly, "SUCCESS")UserForm1.HideUserForm3.ShowElsex = MsgBox("Invalid Username or Password", vbInformation, "Password")End IfEnd Sub[COLOR=#3E3E3E][B]

here the sample if i always use ElseIf Statement after register so many elseif xD and if the cells don't have data the problem i can login without data so xD
i find thread that match data from sheet but i can't edit cuz i'm noob newbie xD thanks [/B][/COLOR]

Re: VBA Excel UserForm User and password LogIn

oh royUk ok xD it gives me this
Office has deteccted a problem with this file. Editing it may harm your computer. click for more details.
xD i don't know lOl
correction of virus lOL

Re: VBA Excel UserForm User and password LogIn

but thanks for helping mo royUK