Hi All,
Iam a new user of VBA. And Iam creating a user login form. I have a work book with 2 userforms in it (Login and Activities). I have another workbook which has the list of usernames and passwords. Now I have to give access to these users so that they should be able to login with their user id, password and their role and once they log in they should be able to view the Activities userform.
Please help me in this.
Thanks in advance...
Hello sn152,
Welcome to the Forum!
Do you the Option Button to set for a valid login?
Sincerely,
Leith Ross
Remember To Do the Following....
1. Use code tags. Place [CODE] before the first line of code and [/CODE] after the last line of code.2. Thank those who have helped you by clicking the Starbelow the post.
3. Please mark your post [SOLVED] if it has been answered satisfactorily.
Old Scottish Proverb...
Luathaid gu deanamh maille! (Rushing causes delays!)
Hi Leith Ross,
Please see the attached updated file.
Thank you!
Last edited by sn152; 04-23-2014 at 01:05 PM.
Hello sn152,
The attached workbook now has a login form. I am sure this will need a little revision to do what you want, but the basic structure is programmed.
User Form "Login" Code
Please Login or Register to view this content.
Hi Leith Ross,
First of all thank you so much for helping me. But with the code that you provided, even if I dont select the role it is letting me to login. Is there a way where only if I select the corrct role, it should allow me to login.
Thanks
Hello sn152,
Here is the update workbook and user form code.
User Form "Login" Code
Please Login or Register to view this content.
Hi Leith Ross,
This is wonderful. This is working fine... Thank you so much for helping me....
Hello sn152,
You're welcome. Let me know if have any more questions.
What sheet does this point too, after the login is successful?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks