Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Entering a long formumla in Validation criteria
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? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering parameter criteria MS Query | Excel Discussion (Misc queries) | |||
Validation - Precede with LR and between 6 and 9 characters long. | Excel Discussion (Misc queries) | |||
Formula too Long for List Validation | Excel Discussion (Misc queries) | |||
Entering information from 1 worksheet to another, if criteria is m | Excel Discussion (Misc queries) | |||
Q on Entering a Criteria within a Query | Excel Programming |