call a VBA function for data validation?

[dlh]

I'm trying use Excel's Data Validation with a custom validation formula,
but the formula length is limited to 255 characters.

In order to use a longer formula, I've implemented a validation
function in VBA. I can call this function from a cell, but when I try
using it in Excel's custom validation formula, it thinks the function
is a named range.

Is there any fix for this short of implementing validation completely
on my own?

-David

 

[Norman Jones]

Hi DLH,

See if the responses from Stephen Bullen and Dave Peterson in the following
thread are of use to you:

http://tinyurl.com/74pug