JohnKauffman
New Member
- Joined
- Nov 1, 2012
- Messages
- 36
Cell A1 uses data validation to restrict range to be within values of cells B1 and C1. Values in B1 and C1 are set from day to day and need no validation.
The A1 data validation includes an input message. Is it possible to include in the text of the input message the min/max allowable values (values in B1 and C1)? I only see way to make the input message boilerplate.
An input message of "values from 10 to 20 are accepted" is better than "check B1 and C1 for allowable values"
(not using VBA in this case)
Thanks.
The A1 data validation includes an input message. Is it possible to include in the text of the input message the min/max allowable values (values in B1 and C1)? I only see way to make the input message boilerplate.
An input message of "values from 10 to 20 are accepted" is better than "check B1 and C1 for allowable values"
(not using VBA in this case)
Thanks.
