Thread: Vba - Password
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Dave Peterson[_3_] Dave Peterson[_3_] is offline
external usenet poster
 
Posts: 2,824
Default Vba - Password

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 procedu

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

"ajliaks <" wrote:

Hi all,

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

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

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

Thanks in advance,
Aldo.

---
Message posted from http://www.ExcelForum.com/


--

Dave Peterson