Entering a long formumla in Validation criteria

S

salgud

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?
 
P

Patrick Molloy

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

salgud

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

Thanks for your reply. I figured out to do that after I posted, but I was
still hoping there is a way to move around in the validation criteria box.
 
A

AB

Thanks for your reply. I figured out to do that after I posted, but I was
still hoping there is a way to move around in the validation criteria box.

There is - once you get to the box hit F2 (as if to edit a formula in
a cell) and the cursor will start moving around as within a text.
Hope it helps.
 
S

salgud

There is - once you get to the box hit F2 (as if to edit a formula in
a cell) and the cursor will start moving around as within a text.
Hope it helps.

Doh! Should have thought of that - from my old Lotus 123 days! Thanks, I
knew there had to be a way.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top