call a VBA function for data validation?

From: dlh <dlh.1tiumc_1123632319.6959@xxxxxxxxxxxxxxxxxxxxx>
Date: Tue, 9 Aug 2005 18:34:49 -0500

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?action=getinfo&userid=26113
View this thread: http://www.excelforum.com/showthread.php?threadid=394420

.

Follow-Ups:
- Re: call a VBA function for data validation?
  - From: Norman Jones

Prev by Date: Re: Retrieving Exchange Rate Data from a Website
Next by Date: Re: Can't set cell value with VBA
Previous by thread: "Compile Error Can't find project or library."
Next by thread: Re: call a VBA function for data validation?
Index(es):
- Date
- Thread

Relevant Pages

Re: Limiting text entries
... My spreadsheet info. starts on row 2 and I ... had forgotten to change the cell references to indicate that. ... For A1 apply the custom validation formula ... limits the number of characters, not the type of characters input. ...
(microsoft.public.excel.misc)
Re: Limiting text entries
... For A1 apply the custom validation formula ... This will allow only entries where the second from last character is a ... comma. ... limits the number of characters, not the type of characters input. ...
(microsoft.public.excel.misc)
Re: Limiting text entries
... Four statements in the AND function, separated by commas check if ... otherwise Excel regards it as text) ... For A1 apply the custom validation formula ... limits the number of characters, not the type of characters input. ...
(microsoft.public.excel.misc)
Re: Limiting text entries
... Four statements in the AND function, separated by commas check if ... otherwise Excel regards it as text) ... For A1 apply the custom validation formula ... limits the number of characters, not the type of characters input. ...
(microsoft.public.excel.misc)
Re: Excel2000: Custom data validation and named ranges
... with cell A1 activated, ... So using dynamic named ranges would be ... >> Let's me have a custom data validation defined for some range of> cells. ... >> I select the range A1:A10 and set custom validation formula as ...
(microsoft.public.excel.misc)