Error Checking in Excel
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 5 of 5

Thread: pls help me, about this validation with user form.....

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I got a list of data, i used validation rules on them. I would like to use a form to add or edit data. But the thing is valiation was ignored if i use user form.

    how can i overcome this problem, any1?

    if i use dialog, will it help???

    pls let me know

  2. #2
    Board Regular
    Join Date
    Mar 2002
    Posts
    73
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    pls help

  3. #3
    MrExcel MVP Russell Hauf's Avatar
    Join Date
    Feb 2002
    Location
    Portland, OR Area - USA
    Posts
    1,607
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    First off, I'd like to caution you against replying to your own message just to get it to the top. I know that some (including myself most of the time) will ignore people who do this. People on this board actually want to help, and will, if you give them a chance. Sometimes I answer posts that are a day or two old. Please be patient.

    That said, just do your validation through VBA. Something like this:

    If Len(TextBox1.Text) > 4 Then
    MsgBox "Invalid Entry"
    Exit Sub
    End If

    -rh

  4. #4
    New Member
    Join Date
    Feb 2006
    Posts
    14
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    in response to your code for the validation in the user form, i was wondering if you or anyone else would know if i am able to set the value of the length between a certain amount and if i am just restricted to text? could i also validate it so that the text box only contains numbers and not letters? thanks

  5. #5
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    73,950
    Post Thanks / Like
    Mentioned
    25 Post(s)
    Tagged
    2 Thread(s)

    Default

    Sofia

    Could you start a new thread?

    I know Russell said he responded to old posts, but he meant posts a few
    days old, not a few years.

    By the way what you are asking is perfectly possible. Can you give more
    details, preferably in a new thread?
    If posting code please use code tags.

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
  •