Data Validation - show actual cell values in validation text

[PeteofEbor]

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 ?

[mikekaganski]

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

[Lupp]

@PeteofEbor

Is there any way to show the actual values of B1 & B2 in the error alert box ?

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!”