Input Masking

Mr Nick · Apr 9th, 2002, 09:13 AM

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 · Apr 9th, 2002, 09:40 AM

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 · Apr 9th, 2002, 09:43 AM

Good Lord.

It's easy when you know how!!

Mark O'Brien · Apr 9th, 2002, 09:44 AM

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

Apr 9th, 2002, 09:40 AM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	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 __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 9th, 2002, 09:44 AM	#4
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	You know what, I know how and it still took me a few minutes to remember. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 09:13 AM	#1
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	How do I apply masking to the text input into a TextBox on a UserForm? Hopefully I get the hang of Excel one day!!

Apr 9th, 2002, 09:43 AM	#3
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	Good Lord. It's easy when you know how!!