Data Validation

[patrick924]

Hi,
Sorry for my english i'm french.

I search how i can indicate that the validation of a cell is a personal
fonction.

i try to put the name of my fonction in the formula (data validation) but
that don't work.

How can i do ?

Thank's all

 

[Frank Kabel]

Hi
AFAIK data validation does not support user defined functions

 

[Debra Dalgleish]

You can't use your User Defined Function in the Data Validation formula,
but you could refer to a cell that uses the UDF.

For example, in cell C3, enter a formula that uses a UDF:
=myCommission(B3)

In cell B3, use the custom validation:
=C3<25