Message box

[Gordy99]

I have a cell that checks the vertical totals with the horizontal totals and
shows the difference if they are difference.
I would like to add a pop up message box if they are different using sheet
code.
Thanks,
Gordy

 

[Jim Thomlinson]

Right click the sheet tab and select view code. Add the following. You will
need to change the cell reference...

Private Sub Worksheet_Change(ByVal Target As Range)
If Round(Range("A1"), 3) <> 0 Then MsgBox "Out of Balance"
End Sub

 

[Bob Phillips]

Surely, vertical totals will be a sum of the column, horizontal totals will
be a sum of the row, so they will be different?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)