Multi-user Login Module in Excel VBA

Today in this tutorial we would learn how to create a login module in Excel so that we can control the multiple users.

First of all we need to think how to develop this module step by step.

Step 1. create and design the user forms

Step 2. transfer the data from userform to worksheet

Step 3. Match the worksheet data by TextBox

If condition satisfied then you will be allowed to access the application. Here you can control the multiple users to access the application. Only admin can access all features.

UserID: Admin
Password: 123

If any one want to use this login module, you can drag and drop the userform into your application.
Write the vba codes for workbook open

If you like this video then comment please and subscribe my channel if didn't

Those who don't understand bengali then visit my blog. I will discuss the same in my blog

For download and vba code see the below link

https://nsutradhar.blogspot.com/2020/10/multi-user-login-module-in-excel-vba.html

Видео Multi-user Login Module in Excel VBA канала Nsutradhar