Userform for password input: Show asterisk instead of the password

[Suril]

I have created a userform for unlocking / locking all the sheets in excel at one go. I want that when the users type in the password, the screen displays merely something like '****' i.e. hiding the entry. Is there a way to do this?

 

[Somendra Misra]

Hi Suril,

Wish you a very happy new year.

You will enter this password in a textbox on userform.
1. Select textbox.
2. Go to properties, you will see there a property password character. Put any character there of you choise. Thats it.

I think this is what you need.

Just advise if any issue.



Regards!

 

[Debraj]

Insert a textbox.. in properties window, select PasswordChar properties.. and set it to "*"

 

[Suril]

Perfect! Thanks a lot! Wish u too a very happy new year