Hi
I want to be have a msg box pop up when the sum of a set of cells (range1) is more than the sum of another set of cells (range2). If range 1 > range 2 is true, then it needs to check a cell (A12) is not blank. If the cell is not blank, do nothing, if the cell is blank then pop up a message "you have too much".
So far i have:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("B26") > Range("B12") Then
MsgBox "WARNING: Total Development day costs are not enqual to total development days charged. Please provide explanation.", vbOK
End If
End Sub
Any help would be appreciated
Thanks
Jessica
I want to be have a msg box pop up when the sum of a set of cells (range1) is more than the sum of another set of cells (range2). If range 1 > range 2 is true, then it needs to check a cell (A12) is not blank. If the cell is not blank, do nothing, if the cell is blank then pop up a message "you have too much".
So far i have:
Option Explicit
Private Sub Worksheet_Change(ByVal Target As Range)
If Range("B26") > Range("B12") Then
MsgBox "WARNING: Total Development day costs are not enqual to total development days charged. Please provide explanation.", vbOK
End If
End Sub
Any help would be appreciated
Thanks
Jessica