When '16 BVL Practice was used, IIRC, the ERR:519 showed. The cells
within my Source were not formatted as text beforehand.
Next time, I will try that Shrink box.
TNX.
On 2/12/2016 4:38 PM, Brian Barker wrote:
At 16:18 12/02/2016 -0500, Vince Bonly wrote:
Came upon one glitch: I did not see a Shrink button in my version
(4.1.2) of AOO on the right of the "cell range" box. What I did see,
after setting the Criteria-Allow to "Cell range", is an input line
after a "Source" prompt.
The Shrink button is to the right of that Source box. It's an
alternative (easier and more reliable) way to fill the box.
I learned that the definition string for my selection choices should
not begin with an apostrophe ( ' ) nor with a [left] arrow ( < ). I
was trying to begin with '16 BVL Practice or <Blank>; neither of
those worked.
That's not true. An apostrophe before a number will be interpreted as
a text format marker and not included in the cell value - but that
shouldn't cause any problem if you have text following it, as you do
here. (There are some complications if you have AutoCorrect set to
change apostrophes to smart quotes.) In any case, you need only to
format the cell range as Text before entering the values to avoid this
problem entirely.
I don't see why <Blank> should be a problem. (It isn't for me.) If you
actually want to be able to accept genuinely empty cells, just ensure
that "Allow blank cells" is ticked in the Validity dialogue.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
