Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Duplicate Text within single cell. How to identify & split | Excel Worksheet Functions | |||
Formulas dealing with text data | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
want to remove all text characters equal to one character in length from text string | Excel Worksheet Functions | |||
Remove single text characters | Excel Discussion (Misc queries) |