VBA: Userform TextBox set to password entry then allow alphanumeric, numeric entry

Hello,

I have a Userform textbox that I set for password entry, I was hoping to let the user input any password that is... numeric only or, letters only or alphanumeric. Any suggestion is very much appreciated.

Thank you

Hi Hudas,

Try this code

Sub PasswordButton_Click()
' This is a code to let supervisor access reporting
UserName = InputBox("Enter password to acces data and Report")
If UserName <> "ste" Then GoTo WrongPassword
MsgBox " Welcome Hematology Supervisor"
ReportForm.Show
MainForm.Hide
Exit Sub

WrongPassword:
MsgBox "Please re-enter password"
End Sub