Mask a Text field

[socko139]

I wanted to mask a text box on a form in Excel. Any idea what the code would look like?

Thanks!

 

[axa]

socko139,

in actual fact, excel's standard text boxes have a built-in masking feature, that is not activated by default.

if you look at the property list for the textbox you will find one named "PasswordChar". enter the masking character of your choice into this property ('*' for example) and you will then find all input into the textbox is masked.

Hope that helps,

axa