Vba - Password

[ajliaks]

Hi all,

I try to use a userform whith a textbox to input Password.

Does anybody knows how to change the alphanumerical characters int
"*"

For example, when inputing "1234" userform must show "****"

Thanks in advance,
Aldo

 

[Dave Peterson]

When you're designing the form, select the textbox.

Hit F4 (to see its properties).
Scroll down to PassWordChar
and type in the character you want to see (*).

or specify it in the initialize procedure:

Option Explicit
Private Sub UserForm_Initialize()
Me.TextBox1.PasswordChar = "*"
End Sub