title: Excel validation list allowing invalid inputs
body: <p>I have a worksheet with several different validation lists using named ranges on a different sheet.  I realized that the cells using the ranges with blanks in them still allow the user to type in whatever they want.  If there's no blank in that defined range, then the normal Excel error message pops up.  Anyone know why this happens?</p>
  
  <p>Ex:<img src="https://i.stack.imgur.com/ffoBd.jpg" alt="enter image description here"></p>
  
  <p>Both types of validation lists are the default settings with "Ignore blank", "In-cell dropdown", and the Error Alert checked.</p>
  
  <p>Some of my lists have spaces in between them but I would still like to restrict users to selecting only the choices provided by the dropdown.</p>
  
  <p>Update:</p>
  
  <p>I tried unchecking the "Ignore Blanks", but one minor issue this causes is that now the user can't press "Backspace" to clear the cell.  They have to actually select one of the blank rows in the drop down list.</p>
  
  <p>I discovered another issue which may only be specific to my code (not the example):</p>
  
  <p>-if the cell already has an option selected</p>
  
  <p>-the user tries to delete the cell via "Backspace" and the Excel error message pops up</p>
  
  <p>-if I click Retry and click on the drop down list again, I get 3 of these:</p>
  
  <p><img src="https://i.stack.imgur.com/zYlbf.jpg" alt="Error 50290"></p>
  
  <p>-the error is from the Worksheet_Change sub and occurs despite me having an error handler within it</p>