+ Reply to Thread
Results 1 to 7 of 7

Validation on a textbox

  1. #1
    Registered User
    Join Date
    09-06-2010
    Location
    Bristol
    MS-Off Ver
    Excel 2003
    Posts
    96

    Validation on a textbox

    Hi guys

    1. I want to put a validation on a textbox means the textbox can only have first two alphabets "EL" and next 6 digits. If the user types something else then display error message. The alphabets should always be "EL".

    Thanks
    Nancy
    Last edited by Nancy123; 09-08-2010 at 07:02 AM.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,331

    Re: Validation on a textbox

    You can use Like:
    Please Login or Register  to view this content.
    for example.
    Everyone who confuses correlation and causation ends up dead.

  3. #3
    Registered User
    Join Date
    09-06-2010
    Location
    Bristol
    MS-Off Ver
    Excel 2003
    Posts
    96

    Re: Validation on a textbox

    Thanks Romper for your reply. But this doesn't seem to work. It always display an error message.

  4. #4
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,331

    Re: Validation on a textbox

    what are you typing into the control?

  5. #5
    Registered User
    Join Date
    09-06-2010
    Location
    Bristol
    MS-Off Ver
    Excel 2003
    Posts
    96

    Re: Validation on a textbox

    I am typing:

    EL123456

  6. #6
    Registered User
    Join Date
    09-06-2010
    Location
    Bristol
    MS-Off Ver
    Excel 2003
    Posts
    96

    Re: Validation on a textbox

    It worked perfectly fine ... I was using a wrong textbox number thats why it gave me prob earlier. Thanks a lot for your help Romper.

  7. #7
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,331

    Re: Validation on a textbox

    No problem - please don't forget to mark this 'Solved'.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1