Data Validation - Error Alert tab

[jimnewguy]

Is it possible to validate a formula and not a direct entry into a cell?

Example:

I want an error message to pop up if B5 = False

cell (B5) =IF sum(B10:B13)>$100, True, False

In this scenario if the formula shows up as False it does not have an error message pop up unless I directly click in the cell and press enter. Is there a way to have the error message appear without clicking in cell B5?

 

[SkipVought]

Hi,

Not without event driven code in VBA.

Skip,
[sub]
[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion! [/sub]

 

[jimnewguy]

Thank you!

 

[firefytr]

Unless you had another cell with conditional formatting and you wanted a visual only, no popup.

-----------
Regards,
Zack Barresse

 

[xlbo]

You could do this with Conditinal Formatting - no pop up but could change cell colour / font etc.....no VBA needed



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question