Forum Discussion
Drop down menus - deleting content
I'm trying to set up a worksheet with a series of drop down lists to allow colleagues to book resources. Set up fine and all seems to be working well, but if a colleague was to make the wrong selection and want to remove their selection it comes up with a The value you entered is not valid The user has restricted values that can be entered in this cell error and won't let the cell be left empty without a value being entered. There must be a way around this, but I've come the the end of my ideas. Would be grateful for any advice. Thanks. .
2 Replies
What happens if you select the cell and hit the Delete key? Data validation will always allow deleting the contents of a cell.
Richard,
the error message is associated with data validation but data validation only validates data that is put in the cell (using the ENTER key) and not deleting data in a cell (using DEL key).
Could you verify that data validation is being used and not a input box which is programmed to react that way?
