Search code examples
c#excel-dna

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


Solution

  • 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