Data Validation - show actual cell values in validation text

English
,
#1

Hi. I’m pretty sure the answer to this is probably ‘no’ but I thought I’d ask anyway…

Is there any way to display the actual value in a cell in either the data validation “Input Help” or “Error Alert” boxes ?
Example: I wish to put a whole number between 0 and 9 into cell A1
The minimum allowed value [ 0 ] is in cell B1
The maximum allowed value [ 9 ] is in cell B2
The validation is to allow any whole number between B1 & B2
Is there any way to show the actual values of B1 & B2 in the error alert box ?

#2

You may use the “Macro” option of Error Alert.

#3

Out of curiosity:
Why do you want this? After all there is the dropdown.
See also
disask114041_validationRelated.ods (10.7 KB)
The error alert may then be “Use the dropdown list!”

#4

Hi Lupp,
The example was deliberately kept simple. The reality is that the value might be a decimal value between, say, -2000 and +2000 or between 0 and +5000, so a drop-down would not be practical. I think it would be useful to tell the user exactly why a value is invalid, rather than just saying it is invalid. I am prepared to accept it can’t be done…

#5

Let’s concentrate on what can be done:
ask114041.ods (20.3 KB)

#6

Depends on what’s “it”.
I would recommend you follow the suggestion by @Villeroy and mark his post as the solution.

See also disask114041_validationRelated_2.ods (12.8 KB) if you are interested in a variant.
In both cases the minimum and the maximum are shown permanently.

Impressum (Legal Info) | Datenschutzerklärung (Privacy Policy)   Content on this site is licensed under a Creative Commons Attribution Share Alike 3.0 license.