ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Password format (https://www.excelbanter.com/excel-programming/302206-password-format.html)

Pierre Archambault

Password format
 
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

Password format
 
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.

--
Regards,
Tom Ogilvy

"Pierre Archambault" wrote in message
. ..
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







All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com