userform textbox data validation

dhoffman · Apr 10th, 2002, 09:05 AM

Maybe I'm stupid but there doesn't seem to be any property for textboxes on userforms that allows one to set up an input mask or some sort of automatic data validation. Do I really need to use code to check the format of the data entered into the textbox?

Tom Schreiner · Apr 10th, 2002, 09:32 AM

Hi
Right click on your forms toolbox, in VBA development environment, choose additional controls...
Look for Microsoft Masked Edit Control
The file name this refers to,if you have it, is in your system folder namely MSMASK32.ocx
This is basically an upgraded textbox which will allow you to pre-format the expected data with a developer defined mask.
If not, use code...
If it's legal, I'll email you the activeX control?
Tom

dhoffman · Apr 10th, 2002, 11:26 AM

Thanks, I checked it out and that control is available to me. I never thought to look at
'additional controls.'

Mr Nick · Apr 10th, 2002, 12:10 PM

Just had a look at this in my copy of Excel and the control is there but if I try to use it I get a message saying that the component is not licensed properly.

What's all that about then?

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

Apr 10th, 2002, 09:05 AM	#1
dhoffman New Member Join Date: Apr 2002 Location: Lawrence, KS Posts: 29	Maybe I'm stupid but there doesn't seem to be any property for textboxes on userforms that allows one to set up an input mask or some sort of automatic data validation. Do I really need to use code to check the format of the data entered into the textbox?

Apr 10th, 2002, 09:32 AM	#2
Tom Schreiner Board Regular Join Date: Mar 2002 Location: Cincinnati, Ohio, USA Posts: 6,824	Hi Right click on your forms toolbox, in VBA development environment, choose additional controls... Look for Microsoft Masked Edit Control The file name this refers to,if you have it, is in your system folder namely MSMASK32.ocx This is basically an upgraded textbox which will allow you to pre-format the expected data with a developer defined mask. If not, use code... If it's legal, I'll email you the activeX control? Tom

Apr 10th, 2002, 11:26 AM	#3
dhoffman New Member Join Date: Apr 2002 Location: Lawrence, KS Posts: 29	Thanks, I checked it out and that control is available to me. I never thought to look at 'additional controls.'

Apr 10th, 2002, 12:10 PM	#4
Mr Nick Board Regular Join Date: Mar 2002 Location: Manchester, UK Posts: 95	Just had a look at this in my copy of Excel and the control is there but if I try to use it I get a message saying that the component is not licensed properly. What's all that about then?