Password character hide

[Romanpete]

I want to create a macro that can accept a string in a form but hide the entered characters as they are typed. Essentially just like a normal log in, can't seem to find how in vba. Thx

 

[skywriter]

I had the same question at one time and the answer is you need to create a user form, the standard input box will not work. You create a text box on the form in which to enter the password. When you look under the properties for the textbox you will see a box labeled PasswordChar and you pick a character. For mine I picked * and when you type the password that is the character that shows up.

 

[Rick Rothstein]

I had the same question at one time and the answer is you need to create a user form, the standard input box will not work. You create a text box on the form in which to enter the password. When you look under the properties for the textbox you will see a box labeled PasswordChar and you pick a character.

You do not necessarily have to use a user form for that functionality (it probably makes for a neater user interface if you do though), an ActiveX TextBox placed on a worksheet (maybe hidden/unhidden as needed) could also be used because it too has the PasswordChar property.

 

[skywriter]

You do not necessarily have to use a user form for that functionality (it probably makes for a neater user interface if you do though), an ActiveX TextBox placed on a worksheet (maybe hidden/unhidden as needed) could also be used because it too has the PasswordChar property.

Rick thanks for sharing that. I know when I wanted to do this I searched through many threads and this was not mentioned once, it was always you have to make a user form.

 

[Romanpete]

Thanks, easy solution, I like it!