Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I have error message when formula is over value?
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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I have error message when formula is over value?
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 ","") -- VBA Noob ------------------------------------------------------------------------ VBA Noob's Profile: http://www.excelforum.com/member.php...o&userid=33833 View this thread: http://www.excelforum.com/showthread...hreadid=553254 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Can I have error message when formula is over value?
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" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |