Setting up Userform Login Functions

[KOBBY123]

Hi am Dominic. i have a login userform called "frmLogIn" but i want the codes that when i click "OK" on the login form will pull up another userform called "frmCustomerInfo" when i type in a username and password stored on an excel sheet called User Register. Thanks

[6StringJazzer]

I have not tested this but would be happy to do so once you put it into your file. You have not given nearly enough information for a final solution but this illustrates the concept. This assumes that the username and password stored on User Register are in cells A1 and B1 respectively.

Please Login or Register  to view this content.

[KOBBY123]

Thank String Jazzer but I have tried your codes but it did not work. What I simple want to do is to place a password on my userform to prevent any unauthorised user to have access to it. So if you know how I can do that I will be grateful if you will show me. Thanks buddy.

[6StringJazzer]

Please review post #2 above and then attach your file.