• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Creating Custom Function in Add-in

JT21

New Member
Hi,


I have copied a custom function into a VBA Add-in. The code runs something like this:

"Function xxyyzz(r As Range) As String

Application.Volatile

Code xxxxxx

End Function"

I have unable to access the function the way I access the normal worksheet functions. I have checked and confirmed that the function is listed in my Insert Function list. However, when I paste and try to use it from the list, an error message "Name?"appears.

I have tried various ways but wihtout success. I am a VBA newbie. Would appreciate some help.
 
Hi, check security level applied to your Excel - if macros are disabled, UDF does not work:

http://office.microsoft.com/en-us/excel-help/change-macro-security-settings-in-excel-HP010096919.aspx
 
Back
Top