View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dave Peterson Dave Peterson is offline
external usenet poster
 
Posts: 35,218
Default 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