CODEWITHSUNDEEP
c#excel-dna
VeryIgnorantPerson
VeryIgnorantPerson

Reputation: 15

Excel-DNA Function not showing description and parameter info

I created a simple UDF using Excel-DNA as follows:

  [ExcelFunction(Description = "Return something")]
    public static string ReturnSomething(string a, string b)
    {
        return a + " - " + b;
    }

When I go to Excel, the function works but the description nor does the parameters required are shown. How do I get them to show?

Image of my UDF

Image of an Excel built-in formula with parameters shown which is expected from my UDF

Upvotes: 1

Views: 1975

Answers (1)

C. Augusto Proiete
C. Augusto Proiete

Reputation: 27828

That is the expected behavior with custom functions in Excel, built with Excel-DNA. The description is only shown in the Insert Function dialog.

If you want to have IntelliSense for the arguments, you can use the Excel-DNA IntelliSense library - https://github.com/Excel-DNA/IntelliSense

a

b

Upvotes: 4

Related Questions