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

  • Thread starter Thread starter Michael Lanier
  • Start date Start date
M

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
 
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
 
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---
 
Back
Top