locked
Drop Down Boxes in Excel RRS feed

  • Question

  • When unchecking allow blanks in settings on data validation and choosing an error alert when moving from a blank cell an error alert does not appear. It was my expectation that moving from a blank cell would generate an error alert. The drop down box functions as expected otherwise. Typing text other than what is on the "list" does generate an error message.
    Thursday, January 28, 2016 12:47 AM

Answers

  • Data Validation will always allow the user to leave a cell blank. You'd need VBA code in the Worksheet_Change or Worksheet_SelectionChange event to prevent the user from leaving a cell blank.

    Regards, Hans Vogelaar (http://www.eileenslounge.com)

    Thursday, January 28, 2016 6:01 AM