Data Validation - editing in any of the input boxes - why does it not behave

Question

Can someone help me understand why when I use normal editing gestures in any of the input boxes within the Data Validation popup, that it behaves so badly. For example, I have the following formula: =AND(LEN(A1)=8, ISNUMBER(VALUE(MID(A1,1,7))), RIGHT(A1,1)="B"). I go to the Formula box and change the B to a Q. The B remains there despite typing over it. However, when I close it and re-open, the Q is there. Or if I try to use an arrow key to move within the text, it starts adding cell references.

I just don't understand why it behaves so differently from any other input box.

hansvogelaar · Answer

NotSoFastEddie&nbsp;
The range/formula text boxes in several dialogs have been buggy for a while now.
I don't know a remedy for the first problem, but the second one is easy: press F2 to be able to move the insertion point in the text box.

notsofasteddie · Answer

HansVogelaar&nbsp;Thanks Hans.&nbsp; You would think that after all these years and the clearly dated interface that this would have been solid.

Forum Discussion

Data Validation - editing in any of the input boxes - why does it not behave