Custom data validation

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 
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?
 
If it is not valid, clear it down.

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

data - validation - list question 2
Combining two non-contiguous lists into one for data validation, with one range being dynamic 0
Data validation formulas 1
Unusual Use for Data Validation? 1
Conditional Data Validation 2
Conditional Data Validation Options 2
multiple data validation 3
Using custom functions within custom validation 4

Back
Top