ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Vba - Password (https://www.excelbanter.com/excel-programming/309139-vba-password.html)

ajliaks[_35_]

Vba - Password
 
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

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


Dave Peterson[_3_]

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



All times are GMT +1. The time now is 05:39 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com