Drop Down List

[TJPCTeach]

I have a drop down list created by using Data> Validation, Allow: List. My source equals for this example the values One,Two,Three. My question, if the answer is not in the list, is there a way you could have them type something in the cell. I tried but you get this error message “The value you entered is not valid. A user has restricted values that can be entered into this cell”. Any help…. much appreciated.
Using Excel 2000

 

[Steve Hartman]

No,not with Data Validation. That's the purpose of data validation...restricting what can be entered in a cell.
This message was edited by Steve Hartman on 2002-10-17 12:03

 

[maxflia10]

In the data validation window under the "error alert" set to "warning or information" this will allow data entry not on the list.

 

[Steve Hartman]

On 2002-10-17 12:28, maxflia10 wrote:
In the data validation window under the "error alert" set to "warning or information" this will allow data entry not on the list.

What version of Excel are you using? 97 and 2000 don't have this .

edit - Ok in 2000 it is a check box for show error alert.
This message was edited by Steve Hartman on 2002-10-17 12:34

 

[maxflia10]

Steve,

'97

 

[TJPCTeach]

Just tried that, and it works great. Thanks for your help.....