ExcelBanter - Data Validation Lists

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Data Validation Lists (https://www.excelbanter.com/excel-worksheet-functions/110231-data-validation-lists.html)

Data Validation Lists

I am filling text into a cells by using
Data--Validation--Lists.
This won't let me enter anything in the cell that is
not on the list.
Is there any way to just write something different
right in the cell (that is not on the list)?
OR is there a better way to accomplish fby
using a different procedure
thanks
Raymond.
--
dzierzekr

Data Validation Lists

On the 'Error Alert' tab, uncheck the 'Show error after invalid data is
entered' button

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"dzierzekr" wrote in message
...
I am filling text into a cells by using
Data--Validation--Lists.
This won't let me enter anything in the cell that is
not on the list.
Is there any way to just write something different
right in the cell (that is not on the list)?
OR is there a better way to accomplish fby
using a different procedure
thanks
Raymond.
--
dzierzekr