VBA - Command Button, Userform, Username and Password

Hello All,

I am new to this whole forum thing as well as VBA.

My question:

I have created (with the help of tutorials and generous people sharing their code(s) and knowledge) a Userform for a Username and Password prompt to access the excel file. It uses Vlookup to look up usernames and password within a table inside the excel file.

Code below:

Formula:

Please Login or Register  to view this content.

I want that same Userform to pop up when a user clicks on a command button. They enter in their Username and Password;

1.) If correct this MsgBox pops up:

Formula:

Please Login or Register  to view this content.

2.) If cancel on this new MsgBox, then end the script.

3.) If incorrect on Username and Password, then they get to attempt their username and password again, until it is correct or until they hit cancel.

Please, any help would be much appreciated, and if you have the time, could you explain the code and process. If not all is well.

Thanks in advance!

Hello gmr4evr1,

Here is the file you have asked for. The Username and Password gives you the debug message once the file is opened. I don't know what that is all about.

Thank you.

try

Please Login or Register  to view this content.