Data Validation lists - entering value not in list
 

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


--
rgarber50
------------------------------------------------------------------------
rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350
View this thread: http://www.excelforum.com/showthread...hreadid=388305

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

Debra

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

Richard


--
rgarber50
------------------------------------------------------------------------
rgarber50's Profile: http://www.excelforum.com/member.php...o&userid=11350
View this thread: http://www.excelforum.com/showthread...hreadid=388305

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