Password format

[Pierre Archambault]

Hi !

I am wondering if there is a way to format a cell so that the text beeing
entered is displayed as password characters (*) instead of the actual
characters. Also is it possible to use a text box in a userform to have the
user enter his password and display it the same way in the textbox ?

Thanks

Pierre

 

[Tom Ogilvy]

You can use a custom number format like this:

;;;"*******"

While editing the cell or looking at it in the formula bar, the password
being typed will be visible.


If you use a textbox from the control toolbox toolbar it has a passwordChar
property which you can set.