Description is not visible in Excel while using in Excel...

Jun 27, 2012 at 9:02 PM

[ExcelFunction(Description = "GetPositionData", Category = "CustomFunctions",            Name = "GetPositionData", HelpTopic = "Gives Position Data Asynchronously")]

public static object GetPositionData(object inPortfolios, object inSecurity)


But none of this attributes are visible when I use it from Excel e.g. Category, Desciption ?

Also when users starts editing formula; I want to show all the parameters i.e. similar to Intellisense in C# .dll... 

How can I do this ?


Jun 27, 2012 at 9:32 PM

Hi there,

The descriptions strings and category information you add in the [ExcelFunction] attribute is used only in the function wizard dialog box. The HelpTopic actually refers to a link inside a .chm help file, so you'd probably add that longer description in the 'Description' of the attribute.

Excel does not not show the Intellisense help for any user-defined functions, whether the UDFs are defined in VBA, the C API or however. This would be a great feature to ask Microsoft to add to a future Excel version, if you have a Microsoft account manager of someone who can escalate that kind of suggestion.