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

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