Mask Password in Input Box

[Kallassy]

Hello,

I have an input box that prompts the user to enter his password to access the sheet. Is there a way to mask the password while it's being written by (*) ?

Thank you

 

[jtakw]

Hi,

You can do that easily with a Userform rather than an inputbox.

 

[Logit]

.
Masking the entered text into an InputBox is not a short task. Review these examples :

https://wellsr.com/vba/2016/excel/mask-your-password-with-this-vba-inputbox

http://www.freevbcode.com/ShowCode.asp?ID=1214


An alternative involves using a UserForm with a TextBox. The TextBox properties are already set up to mask entries with an asterisk " * ". You can make the Userform and Textbox look like an Input Box.

https://stackoverflow.com/questions/28189864/excel-vba-input-box