Changing password characters on userform

[kidwispa]

Hi,

i've created a userform that I want to password protect, and it is all working fine, however i would like the password characters when input to show **** instead of what is being typed.... can anyone help?

Here is my code so far:

Private Sub CommandButton1_Click()
If Me.TextBox1 = "Password" Then
UserForm1.Show
Else
MsgBox "You do not have permission to view this report"
End
End If
End Sub

Thanks

 

[JamesW]

Hi there,

Right click on your textbox, goto Properties and in the Password Char field enter *

 

[GTO]

During design time, select the textbox and look in the properties window. Enter the preferred character in PasswordChar

 

[kidwispa]

Thanks for your quick replies! All sorted!!