Grab the Free VBA Quick Reference Guide
https://www.chrisjterrell.com/excel-vba-quick-reference-guide/
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