Hello, I'm currently learning excel and vba. I was tasked to create a program and a part of it is to allow users to log in. In a separate userform, the user registers their account together with their other information. The next step is to enter the new user form to login and see their application status. My question is how do i search and verify the username (matric number) and set the search within the same row such that both values are verified before showing the next userform for them to see their application status.
below is a picture of my current stuck VBA code and a picture of mentioned database.
Using the above code that i referenced from another post here, there weren't any errors but even with the right matric number and password, it still said that sign-in was unsuccessful.
FYI, The registration userform receives and sends the obtained information to the database (Sheet2). The purpose of the SignIn userform (the one in the picture) is to validate the inputs for signing in before adding the information to SignIn2 (the following userform) and displaying it for them to see their status.
Any input, advice or reference is greatly appreciated. Thank you!
below is a picture of my current stuck VBA code and a picture of mentioned database.
Using the above code that i referenced from another post here, there weren't any errors but even with the right matric number and password, it still said that sign-in was unsuccessful.
FYI, The registration userform receives and sends the obtained information to the database (Sheet2). The purpose of the SignIn userform (the one in the picture) is to validate the inputs for signing in before adding the information to SignIn2 (the following userform) and displaying it for them to see their status.
Any input, advice or reference is greatly appreciated. Thank you!