the validation formula should provide a true or false. so just put the same
formula into a cell to test it

"salgud" wrote in message
.. .
I'm entering a long (about 180 characters) into the data validation
formula
box. It takes the formula, but tells me there is an error in it. But I
can't edit the formula because I can't navigate in the Validation formula
box. The arrow keys insert a cell address instead of moving the pointer
(XL2003). I also tried Alt arrow, Ctrl Arrow and Shift arrow, but none of
those work either. Any ideas how to move the cursor in the Data Validation
custom formula box?