custom alert message

J

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
 
J

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

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.
Click to expand...

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.
 
Top