Can I have error message when formula is over value?

[dvozar]

I need an error message to appear when a range of cells is to more than 24
hrs. The "validation" command only allows for data typed into that cell
directly to have an alert. How can I have a message alert for a cell that
has a formual?

[VBA Noob]

Have you got some sample data.

Are you saying you can't use Data Validation to do this.

How about a Forumla in the next cell.. Something like

=IF((SUM(J14:J15)*24)>24,"<<< Error !!, Time cannot be more than 24 hrs ","")

[Dana DeLouis]

One option might be to place code similar to the following in the module for
the specific worksheet.
Here, I assume A10 has your Sum( ) function.

Private Sub Worksheet_Calculate()
If Range("A10") > 1 Then
MsgBox "A10 is greater than 24 Hours"
End If
End Sub

--
HTH. :>)
Dana DeLouis
Windows XP, Office 2003


"dvozar" <[email protected]> wrote in message
news:[email protected]...
>I need an error message to appear when a range of cells is to more than 24
> hrs. The "validation" command only allows for data typed into that cell
> directly to have an alert. How can I have a message alert for a cell that
> has a formual?