Macro to cause a password to display ooooo's or other symbols

[Michael Lanier]

When a pasword is entered, is there a way to make the password's
symbols display zeros instead? For example, if A1 is the cell in
which 10 symbols are entered, can the 10 symbols be made to appear in
B1, while the password entry originally entered in A1 displays 10
zeros (or blackened circles as is common to most encrypted passwords)
instead? Thanks for any help you can provide.

Michael

 

[Mike H]

Hi,

The most common way of doing this is to get the password in a textbox on a
userform with the textbox 'Password Character' property set to (say) and
asterix.

Mike

 

[ryguy7272]

Assuming a UserForm, add a TextBox, right-click the TextBox, then go to the
TextBox properties, there is a property called PasswordChar, set this to *

HTH,
Ryan---