Thank you Mike for responding to my post.

Can you please elaborate your solution. I am not familar with PUBLIC
FUNCTION. May be you could use the info I posted to explain.

Thanks in advance


"mike" wrote:

Public Function test(number As range)

If number 10 Then

MsgBox "Result is too large"

Else: test = number

End If

End Function

jpreman wrote:
Thanks for your post Jim.

The first point is I am NOT referring to data entry validation.

Let me give a simple example.

sum(A1:E1)=F1. But the results in F1 should not exceed 10. If it does there
should be a popup message.(I am NOT looking for conditional formatting)

Thanks once again



"Jim Thomlinson" wrote:

Your description is a little thin on details but in general you are probably
looking to use the Custom option in data validation. You specify a formula
and off you go...
--
HTH...

Jim Thomlinson


"jpreman" wrote:

Thanks for reading this post.

Data/validation is used for data entry in a cell.

Is there a way validations could be applied based on the results in a cell.
ie. if a desired result is not reached there should be a customised error
message/alert