Change text to a single characters
 

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!

Change text to a single characters
 

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.

Fitri Nadyra wrote:

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