Invalid username Msgbox and Run time error

[sn152]

Good Evening All,

I have a code for userform login. The users will enter their user name, password, and role and then click on submit. The user names, password and roles are given in the sheet "user access".

Now the problem is if a user enters a wrong user name which is not on the sheet "user access", it gives a msg stating invalid username. And if I click ok it is showing a run time error. Is there a way to stop showing this run time error and just show the invalid username msg box alone.

Kindly help me with this.

Thanks in advance....

[playaller]

(Open the login form and right click and view code on the SUBMIT button)


You need to change the command button line from:

Please Login or Register  to view this content.

to

Please Login or Register  to view this content.

As you have it, it doesn't give any instructions for errors, it tries to proceed as normal. The update will stop the process at the login level until successful or closed.

Updated file attached:

[sn152]

Hi,

Thank you so much. This was very helpful.

[playaller]

Anytime! Don't forget to mark the thread as solved.