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

Thread: validation

  1. #1
    New Member
    Join Date
    Mar 2002
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hi, i am having trouble with writing a project, i want a text box in a membership form, and i want people to enter a post code, and i want it to only allow the correct ammount of charachters to be entered, e.g ll68 abc, and if it is entered incorrectly then an error message would pop up. can anyone help me as this is really troubling me. any help would be much appreciated

    BoB

  2. #2
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-18 01:39, canablitz wrote:
    hi, i am having trouble with writing a project, i want a text box in a membership form, and i want people to enter a post code, and i want it to only allow the correct ammount of charachters to be entered, e.g ll68 abc, and if it is entered incorrectly then an error message would pop up. can anyone help me as this is really troubling me. any help would be much appreciated

    BoB
    Hi Bob
    The textbox has a property
    Maxlength....set this to your max length.

    To view the textboxs propetties
    Just press F4 while in the VBE editor


    HTH


    Ivan

  3. #3
    New Member
    Join Date
    Mar 2002
    Posts
    26
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    hello

    I have a password to allow users to enter, they sign up and choose passwords. But, i was waundering if its possible to make the computer actually recognise the user and remember their details, eg. address

    thnks alot Craig

  4. #4
    MrExcel MVP Ivan F Moala's Avatar
    Join Date
    Feb 2002
    Location
    Auckland, New Zealand
    Posts
    4,209
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    On 2002-03-18 01:53, Craig AS wrote:
    hello

    I have a password to allow users to enter, they sign up and choose passwords. But, i was waundering if its possible to make the computer actually recognise the user and remember their details, eg. address

    thnks alot Craig

    Basically
    Use a seperate sheet to record there details
    Hide this sheet.
    Use workbook open & a userform to get
    the info and do a check against the data
    you have in the hidden sheet.

    There are a lot of ways to do this.....
    have a go @ trying to do this.
    If you get stuck then repost with your problem and I'm sure
    someone will help


    Ivan

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
  •