If there is a list type validation at a cell, user can't press "Yes" button to force a invalid text.
- open a excel file with list type validation
- using attached file validation.xlsx
- input a invalid text into the cell with list type validation as following shows:
- press the "Yes" button
- the dialog will show again until you press Cancel or No button