Data Validation - Custom function VBA

[webdevptg]

PS: translate by Google translate ?

Hi,

have a function VBA that verifies the Portuguese TIN is valid (Como validar um NIF no Excel - www.JJoao.com) through the control digit and intended to use this function in the validation of data, in order to inform the user if the number was not valid, since the function returns a boolean value.

For example in cell A1, I create a custom data validation and place = verificaNIF (A1), but I get an error stating:


Cannot find a range with the name you specified


There is no problem in userform or Vba, but this cell validation must be included in cells.

What am I doing incorrect?


Thanks

 

[kennypete]

Data validation's formula cannot be a user-defined function directly. You can, however, have it look at a cell that utilises the UD function. (And that could be in a hidden Worksheet if you don't want it to be obvious.)

So, to illustrate, this works (where the function YN returns a TRUE/FALSE for even/odd values):

where B1 has a data validation formula of

In my example above, my YN function is

Function YN(x As Integer) As Boolean
    If x Mod 2 = 0 Then YN = True
End Function

So if 1,3,5,... is entered into B1:

 

[webdevptg]

Work's fine...

I'll share