Validation of cell results

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

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

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

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

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
>
>