I've noticed that for most validation tasks, the Data Validation... feature
just doesn't cut it -- it's simply not powerful and flexible enough.

But if you're looking at the validation result in VBA anyways, why don't you
perform the validation programmatically as well? In VBA it's more or less a
no-brainer. Is there some kind of odd user requirement that forces you to use
Data Validation rather than a proper programming language?

Cheers,
/MP

"Hemant_india" wrote:

thanks Ardus
but the condition is such that
i must validate through...
Data------validation---------
and i am using
"if validation=true" in vba code to check each cells value


--
hemu


"Ardus Petus" wrote:

Try:
=LEN(A1)+LEN(B1)+LEN(C1)0

HTH
--
AP

"Hemant_india" a écrit dans le
message de news: ...
hi
i have thre columns of which at least one should contain some text
how do i validate such condition?
thanks

--
hemu