UserForm password masking not working

[KarinG]

Hi.
I created a UserForm that accepts a password. The property PasswordChar is set to *. This works great in Excel 2010. When I try using the form in Excel 2016 it does not work. The password is literally all asterisks. Any idea on what is happening and how I fix this? I really would like the password to be what I type in and not all stars.
Thanks for your help.
Karin

 

[Kenneth Hobson]

Welcome to the forum!

I can not duplicate your problem. Both Value and Text properties return the proper string.

Private Sub CommandButton1_Click()
  MsgBox TextBox1.Value
End Sub

 

[Fluff]

@KarinG
Could you post the userform initialize code?

 

[KarinG]

Hi.
Thanks for the quick replies. My msgbox displays all asterisks.
Here is my code:

Private Sub cmdSubmit_Click()
    On Error GoTo PasswordError
        MsgBox txtPassword.Value
        For Each ws In ActiveWorkbook.Worksheets
            ws.Unprotect Password:=txtPassword.Value
        Next ws
        Me.Hide
        txtPassword.Value = ""
        MsgBox "All worksheets unlocked"
    Exit Sub
PasswordError:     MsgBox "Invalid password - please try again."
    txtPassword.Value = ""
    Me.txtPassword.SetFocusEnd Sub

 

[Fluff]

Do you have an initialize event for your userform?
Or any other code in the Userform module?

 

[KarinG]

There is no initialize event. The only other code in the module is this:

Private Sub UserForm_Activate()
    Me.txtPassword.SetFocus
End Sub

To call the form I use this code:

Sub UnProtectAllSheets()
    frmPasswordUnprotect.Show
End Sub

 

[Fluff]

Not sure why that's happening, & can't find anything on the net that's similar.
One possible option would be to delete the textbox & then put a new one on.

 

[KarinG]

I can try that. Thank you.

Are there any other properties that I should be checking? Or is PasswordChar the only property that is needed for passwords to be hidden?

 

[Fluff]

Just change the PasswordChar property

 

[KarinG]

I deleted the text field and added it back again. When I leave the PasswordChar field blank it works. As soon as I put a * in that property it doesn't work anymore.