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

"Michael Lanier" wrote:

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

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---
--
Ryan---
If this information was helpful, please indicate this by clicking ''Yes''.


"Mike H" wrote:

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

"Michael Lanier" wrote:

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