Login Form

[sn152]

Good Morning All,

I have a userform (Login), which allows you to login by entering your username, password and by selecting your role.
When you enter the username, password and role and click on submit, it shows another userform (Activities).


Now what I want is, when i enter username, password and select the role as team manager and click on submit,
it should show the userform - "Manager_Login". For all other roles, it should show the userform - "Activities".
The usernames, passwords and roles are on the sheet - "User Access".


it would be really great if someone could help me with this.


Thanks in advance!

 

[Deepak]

Hi,

This query might be asked here.
http://chandoo.org/forum/threads/user-access.16146/#post-98301


However pls change the below line.

Activities.Show

to

If r = 2 Then
    Manager_Login.Show
Else
    Activities.Show
End If