If I have Range A1 limited only to values "Yes" or "No", when I try to enter "Maybe" I will usually get an alert saying that it's not a valid value and it returns to the original value.

However, if I run the following sub there is no alert displayed and the value is entered with no problem.

Sub maybe()


Range("A1").Value = "Maybe"


End Sub