userform textbox data validation

[dhoffman]

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?

 

[Legacy 98055]

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]

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

 

[Mr Nick]

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?