CODEWITHSUNDEEP
excelexcel-2007excel-2010
Suraj
Suraj

Reputation: 36547

How can I get intellisense to work for UDFs in XLAM files?

I have some UDFs in an XLAM file. Intellisense doesn't seem to pickup these UDFs when the XLAM is installed as an add-in. The UDFs themselves work fine in Excel, its just that they don't appear in intellisense. Here I mean intellisense when used on a worksheet.

Upvotes: 3

Views: 1986

Answers (2)

Charles Williams
Charles Williams

Reputation: 23520

There (is) was no way of getting a UDF (VBA, XLL etc) to supply intellisense. This has often been suggested to the Excel team as a worthwhile improvement.

(see https://fastexcel.wordpress.com/2016/10/07/writing-efficient-vba-udfs-part-15-adding-intellisense-to-your-udfs/)

Upvotes: 4

Govert
Govert

Reputation: 16907

With the Excel-DNA IntelliSense extension you can add in-sheet IntelliSense for your VBA-based UDFs (as well as .xll-based UDFs from Excel-DNA, PyXLL or one of the C/C++ toolkits).

The announcement and discussion of the IntelliSense extension is here: https://excel-dna.net/2016/11/24/excel-udf-intellisense-for-excel-dna-and-vba/

A detailed write-up on adding in-sheet IntelliSense to a VBA project (by Charles Williams) can be found here: https://fastexcel.wordpress.com/2016/10/07/writing-efficient-vba-udfs-part-15-adding-intellisense-to-your-udfs/

Upvotes: 1

Related Questions