For Next Loop - If Then

Hello,

I am looking for vba code that uses For Next Loop with If Then in between that tests a username and password login in excel and tests to see if the combination is valid. If not it fails it if so it is successful. If any combination is in error it should fail it. The code is broken up because I started using a form to create it which was working however the requirement is to use For, Next, Loop with If Then to test the login credentials against a table within the workbook. This is the code.

Please Login or Register  to view this content.

I don't know if I didn't understand something?
Use with UserForm.

Please Login or Register  to view this content.

Artik

I had it working with my original code using the form. See below. I need to do it without the form below and use For Next Loop with If Then's in the code where it shows for every row it checks the username and password using If Then. Then at the end it shows Next i for the next row.

Please Login or Register  to view this content.

I still don't fully understand what exactly you want to get, so you have two macros. The first, 99 times you will be asked for your username and password. The second macro will only ask for the password for the user tested in the loop. If you press Cancel at any of the questions, the macro will exit.

Please Login or Register  to view this content.

Please Login or Register  to view this content.

Artik