PDA

View Full Version : [SOLVED] Data Validation List



mike575
06-01-2005, 06:02 PM
I have a question on data Valadation List. I understand how to make and define a list and create the drop down arrow for each cell that I want to use a list in. My Problem I would also like the ability to manual type in data that is not in the list how is that done? :banghead: Currently I get error message that cell is protected. I have the cell unprotected under Format|Cells.

Jacob Hilderbrand
06-01-2005, 10:13 PM
Data | Validation

Click over to the Error Alert tab.

Uncheck the box so the alert will not be shown.

mike575
06-02-2005, 10:38 AM
Thanks for the info, I did find it and that fixed my problem.