Results 1 to 5 of 5
  1. #1
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Validation List ? (Excel 2002/2003)

    Hi

    Please see attached, I have data validation cell I am trying to add a new name to the list if I enter it in Cell C2 of the data validation list.

    Any Ideas please

    Braddy
    If you are a fool at forty, you will always be a fool

  2. #2
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Validation List ? (Excel 2002/2003)

    Brady: In your Data Validation, you need to go the Error Alert tab and remove the check mark next to "Shoe error alert after invalid data is entered.
    Legare Coleman

  3. #3
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Validation List ? (Excel 2002/2003)

    <P ID="edit" class=small>(Edited by Jezza on 04-Nov-06 19:27. Ignore this advise as I had not seen the underlying code and assumed it was just the listing in the second sheet. See [Post: 611,796])</P>Hi Alan

    You don't add to the cell C2 you have to add to the bottom list in the Lists Tab
    Jerry

  4. #4
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Validation List ? (Excel 2002/2003)

    Hi Legare

    Thank you very much everything now works fine.


    Regards

    Braddy
    If you are a fool at forty, you will always be a fool

  5. #5
    Silver Lounger
    Join Date
    Dec 2000
    Location
    Northampton, Northamptonshire, England
    Posts
    1,951
    Thanks
    2
    Thanked 1 Time in 1 Post

    Re: Validation List ? (Excel 2002/2003)

    Hi Jerry

    Thanks all the same.

    Legare's answer did it for me.

    Braddy
    If you are a fool at forty, you will always be a fool

Posting Permissions

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