I’m happy to announce the first official release of the IntelliSense extension!
Excel-DNA IntelliSense provides on-sheet help for UDF functions as they are entered into a cell formula, similar to the help available for built-in Excel functions.
For Excel-DNA add-ins (v0.32 and later) that already provide descriptions in the [ExcelFunction] and [ExcelArgument] attributes, no extra work is needed.
Just download and open (or install) the latest ExcelDna.IntelliSense.xll add-in from the GitHub (https://github.com/Excel-DNA/IntelliSense/releases
), and the IntelliSense will light up. (There is also a NuGet package for embedding the service into your add-in, making distribution a bit easier.)
For VBA functions, you can add an extra sheet with the IntelliSense descriptions, or add an external .xml file with the information, or embed as a the CustomXML part in the Workbook or .xlam add-in.
Other native .xll add-ins can also provide IntelliSense through an external .xml file.
Details and downloads are on GitHub:
Public support and bug reports:
Corporate support and private donations:
If you find Excel-DNA and extensions like the IntelliSense service useful, please support the project by arranging a corporate support agreement, or making a donation via PayPal. See https://excel-dna.net/support/
for details and contact information.