Data Validation Lists

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

If formula and Data Validation parallely 1
Data validation - critical 2
Linked Lists / Data Validation - Excel 97 1
Checkboxes within a list 5
Data Validation List from a Dynamic Named Range on Another Workshe 5
a data validation list that contains a list of named ranges - not alist from a named range 1
Second cell in Data Validation 3
custom data validation on cells with data validation values 2

Back
Top