5 pts.
 Validation in Excel
Can a cell have a validation rule from a list and also have the ability to free type in that cell? This is in Excel 2003.

Software/Hardware used:
ASKED: March 27, 2008  4:15 PM
UPDATED: May 17, 2008  5:31 PM

Answer Wiki:
I assume you are using Data Validation to create a list of valid entries for a cell. If so, you don't need to use the dropdown validation. As long as you type an entry from the data validation list, it will allow you to do so. HTH, JP
Last Wiki Answer Submitted:  April 8, 2008  12:07 pm  by  JP2112   475 pts.
All Answer Wiki Contributors:  JP2112   475 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _


 

Is the question – Can I have a list validation rule but still allow free text entries, say as an exception or in lieu of an “Other” list item?

If so, simply do not turn on the Error Alert (3rd tab of Data Validation). That way the user can still benefit from the drop-down list, but have flexibility to handle exception.

I don’t believe this is a good database management technique, but I’ve used it myself many times.

 10 pts.