In the data validation help text there is a nice example where the error
alert shows a maximum value that is based on a formula (commissions cannot
exceed $36,000) is the example.

I want to do something similar but cannot find anything that tells me how to
include a formula in that error message.

Thank You

Type the formula in the message:

http://www.contextures.com/xlDataVal04.html


--
Gary''s Student - gsnu200762


"Jim Hunt" wrote:

In the data validation help text there is a nice example where the error
alert shows a maximum value that is based on a formula (commissions cannot
exceed $36,000) is the example.

I want to do something similar but cannot find anything that tells me how to
include a formula in that error message.

Thank You

I guess I wasn't clear. When I type the formula in the message, it shows the
literal formula, not the calculated result. BTW this is Excel 2007. Thanks

"Gary''s Student" wrote:

Type the formula in the message:

http://www.contextures.com/xlDataVal04.html


--
Gary''s Student - gsnu200762


"Jim Hunt" wrote:

In the data validation help text there is a nice example where the error
alert shows a maximum value that is based on a formula (commissions cannot
exceed $36,000) is the example.

I want to do something similar but cannot find anything that tells me how to
include a formula in that error message.

Thank You

hi, Jim !

In the data validation help text there is a nice example
where the error alert shows a maximum value that is based on a formula
(commissions cannot exceed $36,000) is the example.
I want to do something similar but cannot find anything that tells me
how to include a formula in that error message.

see John Walkenbach's Oddities, Weirdness, Minutia, etc...
A user-defined function can't change the worksheet. Or can it?
http://j-walk.com/ss/excel/odd/odd06.htm (from David Hager)

this oddity can also be used to change <range.Validation.ErrorMessage

hth,
hector.