Help with Username and Password Verification.

Beh00

New Member
Joined
Jul 7, 2022
Messages
1
Office Version
  1. 365
Platform
  1. Windows
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.

1657237387609.png
1657237455030.png


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!
 

Excel Facts

Round to nearest half hour?
Use =MROUND(A2,"0:30") to round to nearest half hour. Use =CEILING(A2,"0:30") to round to next half hour.

Forum statistics

Threads
1,223,228
Messages
6,170,871
Members
452,363
Latest member
merico17

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top