custom alert message

[Jim Hunt]

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

 

[Gary''s Student]

Type the formula in the message:

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

 

[Jim Hunt]

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

 

[Héctor Miguel]

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.