How to Create a Login and Registration Form Using Excel VBA|Full Tutorial #2

Number of interfaces available in the project:

 Main interface

• Username. This is for entering the user's username
• E-Mail. This is for entering an email address
• Forgot your password (Click here). Enables an interface named Forgot your password to change the password
• Show. It is for displaying or hiding the characters of the password
• Remember me. When this option is selected, the data about the user can be automatically retrieved from the database by pressing the left mouse button twice in a row
• Login as administrator. As the name suggests, it is for logging into the system as an admin
• Login
• Don’t have an account (Click here). It's for registration. When you click on the button, the corresponding interface is activated

 Don’t hava an account

• Last name. This is for entering the user's last name
• First name. This is for entering the user's first name
• Username. This is for entering the user's username
• E-mail. This is for entering an email address
• Password. This is for setting the password
• W_Username. It is set automatically
• Add photo. It is for importing an image from any directory
• Requirements. Password requirements to be set. When the button is pressed, the corresponding interface is activated
• Confirm

 Forgot your password

• E-Mail. This is for entering an email address
• Verification code 1. This field is for entering Password 1
• Verification code 2. This field is. for entering Password 2
• Your password. This field is for setting the password
• Get code. It is for generating Password 1 and Password 2 and sending it to the e-mail address
• Requirements. Password requirements to be set. When the button is pressed, the corresponding interface is activated
• Confirm

 Password requirements

• Password length: 10 characters
• Must contain at least 1 uppercase letter
• Must contain at least 1 lowercase letter
• Must contain at least 1 digit
• Must contain at least 1 of these characters: ?!/_@

 Admin privileges 1

• Username (Search). It is for searching by username
• E-Mail (Search). It is for searching by e-mail address
• Add. It's for registration. When you click on the button, the corresponding interface is activated
• Update. It is for updating user information in the database
• Delete. It is for deleting data from the main database. When this operation completes successfully, the deleted data is transferred to another table
• Restore. It is for restoring 1 deleted data or all deleted data. Clicking this button activates the corresponding interface

 Admin privileges 2

• Delete. It is to completely delete the data from the database. Only 1 data is deleted at a time
• Delete All. It is to completely delete the data from the database. All data is deleted at once
• Restore. Only 1 data can be restored at a time. In this case, the restored data is returned to the main database
• Restore All. All data can be restored at once. In this case, all data is returned to the main database

---------------------------------------------------------------------------------------
💎 My expectation for this video is 100K views. Please share this video that I made so that more people will be aware of this video
---------------------------------------------------------------------------------------

Buy a Cofee ☕ for theworldofalgorithms: https://ko-fi.com/theworldofalgorithms

🥰Thank you for the donation. I am deeply grateful for your help!🥰
----------------------------------------------------------------------------------------
@MrBeast
#excel
#msexcel
#msexceltutorial
#msexcelcourse
#vba
#vbatutorial
#excelvba
#fulltutorial
#excelvbatutorial
#microsoftexceltutorial
#tutorial
#exceltutorial
#advancedexcel
#advancedexceltraining
#tutor
#exceltutor
#exceltutoring
#exceltutoringonline
#onlineexceltutoring
#algorithm
#algorithms
#programming
#program
#script
#vbamacro
#vbamacros
#usingmacro
#veryuseful
#useful
#veryusefulmacro
#freeeducation
#freeprogramming
#freelancer
#excelfreelancer
#vbafreelancer
#freelanceservices
#microsoftofficespecialist
#microsoftexcelexpert
#vbauserform
#excelvbauserform
#login
#loginsystem
#loginform
#registration
#registrationsystem
#registrationform