View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Mike H Mike H is offline
external usenet poster
 
Posts: 11,501
Default Macro to cause a password to display ooooo's or other symbols

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