Data Validation lists - entering value not in list

[rgarber50]

I want to have an incell drop down list - but I also want to enter an item not on the list. Most of the time the drop down list is fine - once in a while I want to enter an item not on the list. Is there a way to set up data validation to be able to do this?

This would be a list of text choices - the list does not consist of values.


Thanks

Richard

[Debra Dalgleish]

In the data validation dialog box, on the Error Alert tab, remove the
check mark from 'Show error alert after invalid data is entered'


rgarber50 wrote:
> I want to have an incell drop down list - but I also want to enter an
> item not on the list. Most of the time the drop down list is fine -
> once in a while I want to enter an item not on the list. Is there a way
> to set up data validation to be able to do this?
>
> This would be a list of text choices - the list does not consist of
> values.


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[rgarber50]

Debra

Thanks! I knew it was something easy and staring me right in the face!

Richard

[Debra Dalgleish]

You're welcome!

rgarber50 wrote:
> Debra
>
> Thanks! I knew it was something easy and staring me right in the face!
>
> Richard
>
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

[jdnkr1]

I had the same question and found this. Thanks so much!