Hide Password Text

jamesparker_1 · Jul 5th 2007

Hi All,

I have a userform that loads up and requests a password before loading another userform full of administrator controls. I would like the text box to * out every character of text as the user types it in so that the password only appears as ******** in the text box.

Is this possible? My code is below:

Code

Private Sub OK_Password_Button_Click()


'Asks for the administrators password and allows access to the options if password is correct


If Password_Admin.Value = "password" Then  'If password is correct...
    
    Unload Me
    Load Administrator  'Load administrator controls
    Administrator.StartUpPosition = 2
    Administrator.Show


Else


    MsgBox ("Password is Incorrect")    'If password is incorrect...


End If


End Sub

Display More

Thanks

James

**Ger Plante** · Jul 5th 2007

Re: Hide Password Text

If the password is being entered in a text box, set the "PassWordChar" property of the text box to "*" at design time.

Ger

**mikerickson** · Jul 5th 2007

Re: Hide Password Text

Chr(165) is the solid bullet that Excel uses

jamesparker_1 · Jul 18th 2007

Re: Hide Password Text

Ah Great! Thanks Guys! I knew there must be a way!

Many thanks for your help!

James

Hide Password Text

Participate now!

Share