Custom data validation

I have several function that needs to be done as part of validation. This
requires that I call a custom function. Is there a way that I can call a
custom function from the data validation? I see many examples that calls
standard Excel functions but I do not see any custom calls.

Also, which is faster? A validation done using the Data Validation or an
event trigger? I will be validating between 10000 and 15000 rows.

For 10000-15000 rows, I would use an event.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Guy Normandeau" <[email protected]> wrote in message
news:[email protected]...
> I have several function that needs to be done as part of validation. This
> requires that I call a custom function. Is there a way that I can call a
> custom function from the data validation? I see many examples that calls
> standard Excel functions but I do not see any custom calls.
>
> Also, which is faster? A validation done using the Data Validation or an
> event trigger? I will be validating between 10000 and 15000 rows.

If I use an event. How can I manually trigger an error condition so that the
user will be forced to re-input the cell with a valid entry?



"Bob Phillips" wrote:

> For 10000-15000 rows, I would use an event.
>
> --
> HTH
>
> Bob Phillips
>
> (remove nothere from email address if mailing direct)
>
> "Guy Normandeau" <[email protected]> wrote in message
> news:[email protected]...
> > I have several function that needs to be done as part of validation. This
> > requires that I call a custom function. Is there a way that I can call a
> > custom function from the data validation? I see many examples that calls
> > standard Excel functions but I do not see any custom calls.
> >
> > Also, which is faster? A validation done using the Data Validation or an
> > event trigger? I will be validating between 10000 and 15000 rows.
>
>
>

If it is not valid, clear it down.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Guy Normandeau" <[email protected]> wrote in message
news:[email protected]...
> If I use an event. How can I manually trigger an error condition so that
the
> user will be forced to re-input the cell with a valid entry?
>
>
>
> "Bob Phillips" wrote:
>
> > For 10000-15000 rows, I would use an event.
> >
> > --
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from email address if mailing direct)
> >
> > "Guy Normandeau" <[email protected]> wrote in
message
> > news:[email protected]...
> > > I have several function that needs to be done as part of validation.
This
> > > requires that I call a custom function. Is there a way that I can
call a
> > > custom function from the data validation? I see many examples that
calls
> > > standard Excel functions but I do not see any custom calls.
> > >
> > > Also, which is faster? A validation done using the Data Validation or
an
> > > event trigger? I will be validating between 10000 and 15000 rows.
> >
> >
> >