Input Masking

[Mr Nick]

How do I apply masking to the text input into a TextBox on a UserForm?

Hopefully I get the hang of Excel one day!!

 

[Mark O'Brien]

Select the text box in your userform design view. Make sure you have the properties window open. If not press "F4".

Scroll down the properties until you find "PasswordChar". Put in whatever you want as the the password character. I like "*" myself.

HTH

 

[Mr Nick]

Good Lord.

It's easy when you know how!!

 

[Mark O'Brien]

You know what, I know how and it still took me a few minutes to remember.