User Defined Function

**efernandes67** · 06-05-2010, 03:54 PM

Hi,

I created an add-in file with a few functions and I activated it.

*** All my functions begin with "udf_" ***

1) If I go to tab Formulas > Insert Functions -> User defined, I can see them and use them.

If I begin to put the begining of the function name in a cell "=udf" why can I see the list of the functions that begin with "udf"?

I tried to put =udf_age("01/01/2000") ant it works.

Regards,
Elio

**romperstomper** · 06-05-2010, 05:09 PM

Which version of Excel are you using? Also did you mean you can see the list, or you can't?

**efernandes67** · 06-05-2010, 05:29 PM

Hi,

I am using Excel 2007.

If I begin to put the begining of the function name in a cell "=udf" why can't I see the list of the functions that begin with "udf"?

Regards,
Elio Fernandes

**romperstomper** · 06-05-2010, 05:41 PM

Did you register the functions? If not, then they won't appear.
For instructions on registering them see here.

**efernandes67** · 06-05-2010, 06:05 PM

I did not register the functions.
Thanks for your help

Elio

**royUK** · 06-06-2010, 01:57 AM

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save