Excel 2007 : UDF- not showing

Hi,
I have created an add-in and I have followed the procedure to insert it into my work-book via the Excel options, add-in etc but it is not showing in the formula list. What should I do.
Thanks
Sara

Hi,

I have defined a UDF and saved it as .xlam file and then installed the plugin. Now I can access UDF in any workbook I open but I am unable to see the UDF in drop-down suggestion list which appears for excel built in function.

For example: my function name is getPDE. So when I type =get in any cell, I did not get getPDE as one of the options.

Can someone please suggest how to do so.

Many Thanks,
Rahul

Originally Posted by se1429

Hi,

If you are trying to create a User-Defined-Function then check this link:

http://www.exceldigest.com/myblog/20...ined-function/

Unfortunately this link does not touch upon the problem I have mentioned.

Originally Posted by royUK

Read this for comprehensive instructions

Addins

Originally Posted by aragon_iit

Unfortunately this link does not touch upon the problem I have mentioned.

When you created the UDF, did you place the code in a Module or within a worksheet or workbook?

UDFs need to be placed in a Module. To insert a Module, click the 'Insert' option on the toolbar in Visual Basic.

That happened to me once. I wrote a subroutine for payroll, and added all the needed functions. When I wrote a function to find ytd totals, I wrote it ABOVE THE SUBROUTINE.

If you cut and paste the function below your subroutine, it should show up.

Michael


Option explicit

function FIND_YTD()
' because this was not entered below the PAYROLL SUBROUTINE, it did not show up in the drop down list
....
end function

Sub PAYROLL( )
...
end sub

Function (the rest of the functions in this area will show up on the list)
end function