Data Validation Excel 2007 entering via dropdown and from a form
Posted on 2011-10-19
I want a user to be able to enter data in a cell only if it is in the dropdown list so I set it up with data validation. If the user tries to type in the cell something that is not in the dropdown he gets a warning and the data isn't changed when he selects cancel.
I also want the user to be able to double click on the cell and get essentially a larger list of values that can be entered into the cell. If he picks something from the form list that is not part of the basic data validation, when he tries to leave the cell he gets a warning. However, in this case, if he hits cancel it accepts the value entered by the form and continues on.
I would prefer that when he uses the form to select a value that is not part of the drop down list, and he is not presented with the warning.
Otherwise it should accpet the value that is either in the drop down list or in the form. But he can't manually type in anything else.