Macro / custom validation help needed

[harvy28]

I have a problem with excel. I'll describe the problem in a shortened way here.

I have 4 cells that contain a percentage. I want the sum of the four cells not to exceed 100%. I want an error message through validation to appear if the sum excedds 100% OR it could be a macro message box.

Many thanks in advance.

 

[Diablo II]

you can in the next cell put and if statment

=if("A1">100, sum excedds 100%,"" )

or you can use the

Private Sub Workbook_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
Sheets("your sheet name").Select
 If Range("A1") = 0 Then
Call MsgExample1
Else
Exit Sub
End If
End Sub
 
[CODE]Sub MsgExample1()
 MsgBox "sum excedds 100%."
End Sub

[/CODE]