login form using arrays

[ifailatexcel]

Hi guys

Ive been given a task to complete and im finding it really difficult and would be grateful if you pros can help me understand and learn where i am having problems using the vba in excel.

currently i have created the userform.

textbox1 input the username
textbox2 input the password
and a command button ( to return the msgbox saying login succesfull or invalid user and pass)

now i have to store the user and passwords using arrays.

so i currently have.

Please Login or Register  to view this content.

and then

Please Login or Register  to view this content.

now this is where i need help.

i need to use a function to check if user (1) matches pass(1) and then return a message to the user saying succesfull or if it is invalid pass or user return a message saying invalid details. (validation). Then continue the rule for the next if user (2) matches pass (2) etc.

could you guys please help i have been stuck on this for around 14 hours now.

Thanks you

[zbor]

Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.

Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.

Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here

I've edit it this time for you.

[Blokeman]

Check this, working file on post #11;http://www.excelforum.com/excel-prog...iple-user.html