+ Reply to Thread
Results 1 to 8 of 8

Data Validation - Also allow items not in list

  1. #1
    CyberSOG
    Guest

    Data Validation - Also allow items not in list

    I want to use data validation to allow users to select the most common
    answers in a drop-down menu, but I also want them to be able to type in
    others that are not listed. I am sure the solution is easy I just can't
    seem to find in on the boards.

    Thanks,

    Jesse


  2. #2
    JulieD
    Guest

    Re: Data Validation - Also allow items not in list

    Hi

    on the error alert tab change from STOP to "warning" or "informtion"

    Cheers
    JulieD

    "CyberSOG" <[email protected]> wrote in message
    news:[email protected]...
    >I want to use data validation to allow users to select the most common
    > answers in a drop-down menu, but I also want them to be able to type in
    > others that are not listed. I am sure the solution is easy I just can't
    > seem to find in on the boards.
    >
    > Thanks,
    >
    > Jesse
    >




  3. #3
    Bernie Deitrick
    Guest

    Re: Data Validation - Also allow items not in list

    Jesse,

    Data Validation can't be made to work that way on a single cell. If you use
    three cells, then you could use a formula in the third cell that was along
    the lines of

    =If(A1<>"",A1,B1)

    A1 would use the data validation, B1 would be free entry, and C1 would have
    the formula.

    You could write VBA code that would do exactly what you want - give a list
    or allow free entry, but that isn't 'easy'

    HTH,
    Bernie
    MS Excel MVP

    "CyberSOG" <[email protected]> wrote in message
    news:[email protected]...
    > I want to use data validation to allow users to select the most common
    > answers in a drop-down menu, but I also want them to be able to type in
    > others that are not listed. I am sure the solution is easy I just can't
    > seem to find in on the boards.
    >
    > Thanks,
    >
    > Jesse
    >




  4. #4
    Dave Peterson
    Guest

    Re: Data Validation - Also allow items not in list

    Data|Validation|Error Alert.

    Give them a nice warning/information message.

    CyberSOG wrote:
    >
    > I want to use data validation to allow users to select the most common
    > answers in a drop-down menu, but I also want them to be able to type in
    > others that are not listed. I am sure the solution is easy I just can't
    > seem to find in on the boards.
    >
    > Thanks,
    >
    > Jesse


    --

    Dave Peterson

  5. #5
    Dave Peterson
    Guest

    Re: Data Validation - Also allow items not in list

    Or even choose not to warn them.

    CyberSOG wrote:
    >
    > I want to use data validation to allow users to select the most common
    > answers in a drop-down menu, but I also want them to be able to type in
    > others that are not listed. I am sure the solution is easy I just can't
    > seem to find in on the boards.
    >
    > Thanks,
    >
    > Jesse


    --

    Dave Peterson

  6. #6
    Bernie Deitrick
    Guest

    Re: Data Validation - Also allow items not in list

    Jesse,

    rse, after I posted this, I simply cleared the check box next to "Show error
    alert after invalid data is entered" on the Alert tab, and Data Validation
    works exactly the way you want when that is done Another day, another lesson
    in Excel....

    HTH,
    Bernie
    MS Excel MVP

    "Bernie Deitrick" <deitbe @ consumer dot org> wrote in message
    news:[email protected]...
    > Jesse,
    >
    > Data Validation can't be made to work that way on a single cell. If you

    use
    > three cells, then you could use a formula in the third cell that was along
    > the lines of
    >
    > =If(A1<>"",A1,B1)
    >
    > A1 would use the data validation, B1 would be free entry, and C1 would

    have
    > the formula.
    >
    > You could write VBA code that would do exactly what you want - give a list
    > or allow free entry, but that isn't 'easy'
    >
    > HTH,
    > Bernie
    > MS Excel MVP
    >
    > "CyberSOG" <[email protected]> wrote in message
    > news:[email protected]...
    > > I want to use data validation to allow users to select the most common
    > > answers in a drop-down menu, but I also want them to be able to type in
    > > others that are not listed. I am sure the solution is easy I just can't
    > > seem to find in on the boards.
    > >
    > > Thanks,
    > >
    > > Jesse
    > >

    >
    >




  7. #7
    Gord Dibben
    Guest

    Re: Data Validation - Also allow items not in list

    Jesse

    Uncheck the option box on the Error Alert Tab.


    Gord Dibben Excel MVP

    On 16 Mar 2005 08:30:16 -0800, "CyberSOG" <[email protected]> wrote:

    >I want to use data validation to allow users to select the most common
    >answers in a drop-down menu, but I also want them to be able to type in
    >others that are not listed. I am sure the solution is easy I just can't
    >seem to find in on the boards.
    >
    >Thanks,
    >
    >Jesse



  8. #8
    CyberSOG
    Guest

    Re: Data Validation - Also allow items not in list

    Thanks all. I knew there had to be easy way, but just couldn't find it.
    There always is a hard way too.

    Peace,

    Jesse


+ 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