call a VBA function for data validation?
 

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


--
dlh
------------------------------------------------------------------------
dlh's Profile: http://www.excelforum.com/member.php...o&userid=26113
View this thread: http://www.excelforum.com/showthread...hreadid=394420

call a VBA function for data validation?
 

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


---
Regards,
Norman



"dlh" wrote in message
...

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


--
dlh
------------------------------------------------------------------------
dlh's Profile:
http://www.excelforum.com/member.php...o&userid=26113
View this thread: http://www.excelforum.com/showthread...hreadid=394420