Using VBA to change cell format if cell causes error

[bearnone]

I am working on a spreadsheet that uses formulas. I hopeing there is a function or VBA macro to react if the the cell input causes an error in the formula cell.

Moreover, I would love to display a msgbox or bubble notification if the user inputs incorrect iformation into a cell that causes an error in the formula that uses that information.

Thanks for any suggestions.

 

[ETID]

have you tried conditional formating and data validation?

they're in the menu drop downs

 

[bearnone]

I have looked into data validation, but to tell conditionally that a formula in another cell is an error is proving impossible.

 

[ETID]

How about the is error function....

i.e.

=if(iserror(a1/b1),"Invalid Input",(a1/b1))


then do conditional format on cells containing "Invalid Input"

 

[Nikita6003]

Or in the Conditional Format Box change the Cell Value Is to Formula Is, and put this formula:
=If(IsError(A1/B1),TRUE,FALSE)

HTH

Cheers
Nikki