call a VBA function for data validation?

dlh · #1 08-09-2005, 07:34 PM

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

#2 08-09-2005, 09:05 PM

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" <dlh.1tiumc_1123632319.6959@excelforum-nospam.com> wrote in message
news:dlh.1tiumc_1123632319.6959@excelforum-nospam.com...
>
> 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
>

Welcome to the Excel Forum

Forum Statistics