Thanks Thanks:  0
Likes Likes:  0
Results 1 to 4 of 4

Thread: userform textbox data validation

  1. #1
    New Member
    Join Date
    Apr 2002
    Location
    Lawrence, KS
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Location
    Cincinnati, Ohio, USA
    Posts
    6,824
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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

  3. #3
    New Member
    Join Date
    Apr 2002
    Location
    Lawrence, KS
    Posts
    29
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

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

  4. #4
    Board Regular
    Join Date
    Mar 2002
    Location
    Manchester, UK
    Posts
    95
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    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?

Some videos you may like

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •