Excel 2007 : UDF- not showing

[sara_noltsis]

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

[davesexcel]

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 Sara,
I don't know what you did, so don't know what you should do, maybe check this out to see if there is a difference in what you did,
http://www.fontstuff.com/vba/vbatut03.htm

[se1429]

Hi,

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

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

[aragon_iit]

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

Hi,

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

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

[royUK]

Read this for comprehensive instructions

Addins

[aragon_iit]

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

Read this for comprehensive instructions

Addins

[romperstomper]

Your post does not comply with Rule 2 of our Forum RULES. Don't post a question in the thread of another member -- start your own thread. If you feel it's particularly relevant, provide a link to the other thread.

Once you do that, we'll get to answering it.

[Rahbee]

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.

[mjglackin]

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