macro to tell me if any of 4 sums do not add up

[tonywatsonhelp]

Hi eeryone,

I have a sheet called bulk and in it i have 4 sums, now these should all add up to the same amount.
and what i want is a macro that when i run it it tells me if any of the sums are wrong

So the cells are E9,F9,G9,H9
AND IF THEY DONT ALL = THE SAME
message box "please fill in yellow blank cells"
thanks
tony

 

[Joe4]

You mean something like this?

Sub CheckSums()

    If Range("E9") = Range("F9") = Range("G9") = Range("H9") Then
        'do nothing if they all match
    Else
        MsgBox "Please fill in the yellow blank cells"
    End If
        
End Sub

I am just guessing back on the limited details you provided.