data validation - on retry drop down won't take focus

[ajm]

when using data validation in a cell, if you enter the something that is not right (for example, you type "yep" in a cell with "YES/NO" validation instead of "Yes") you get an error message with two buttons: Retry and Cancel. How come when you hit retry, and you are taken back to your cell, you can't then just use the drop down arrow to select your answer. Doing this makes the error message pop up come back. I actually have to hit cancel to get out before I can re enter something to the cell.

here's what code I am using:

With Sheets(i).Range("S26").Validation
            .Delete
            .Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
                 xlBetween, Formula1:="YES,NO"
                 .InCellDropdown = True
            .ErrorTitle = "Value error"
            .ErrorMessage = "Yes or No? Have in year savings been affected?"
        End With
        With Sheets(i)
            .Range("t26") = "-"
            .Range("S27").Value = Date
        End With

 

[ajm]

bump