In this Macro Monday Challenge, create a userform that will mask the text like a password.

‘Form Code

Private Sub CommandButton1_Click()
If TextBox1 = “ABC123” Then
UserForm1.Hide
MsgBox “Yay the password was correct”
Else
MsgBox “wrong password”
End If
End Sub

Private Sub CommandButton2_Click()
Unload Me
End Sub

‘Module Code
Sub callForm()
UserForm1.Show

End Sub

Chris Terrell

View all posts