How to create Login page by using Excel VBA Userform with passwordchar.

How to create Login page by using Excel VBA Userform tutorial for beginner and advance learner and how to check password by clicking checkbox to show character of password .You could learn how to create textbox, checkbox, command button and label by using Userform VBA. Fistly, we create template for our login page. Then, we create two macros.One is related to command button and the other one is related to checkbox to show your password correctly.
You could see code in below.
Private Sub CheckBox1_Click()
If UserForm1.CheckBox1.Value = False Then
UserForm1.TextBox2.PasswordChar = "*"
Else
UserForm1.TextBox2.PasswordChar = Empty
End If
End Sub
Private Sub CommandButton1_Click()
If UserForm1.TextBox1.Value = "Admin" And UserForm1.TextBox2.Value = 123456 Then
Me.Hide
MsgBox ("you login the page")
Else
MsgBox ("You enter wrong password or wrong username")
End If
End Sub
#ExcelTutorial #MicrosoftExcelTutorial #Excel #ExcelVBA
#Exceldashboard #Excelpivottable #Excelcourse #vbaforbeginners #vbamacrosinexcel
#Userform #MSExcel #MicrosoftExcel #ExcelTutorial #excelTutorial #excelTutorialForBeginners #excelCompleteCourse #ExcelFormulas #ExcelFunctions

Видео How to create Login page by using Excel VBA Userform with passwordchar. канала Man Whisper to Codes