Change text to a single characters

[Guest]

I have created a log in box in VBA. When the user types in their password, it
will not appear as the password but characters instead, in this case the
symbol *.

Is there a formula to do the same without using VBA?

Thanks!

 

[Dave Peterson]

Nope.

You need that userform and password character.

You could kind of cheat.

Format a cell with a custom format of:
"*****";"*****";"*****";"*****"

You'll see those asterisks in the cell--but the real value in the formula bar.