如何获得Intellisense来处理XLAM文件中的UDF? [英] How can I get intellisense to work for UDFs in XLAM files?

问题描述

我在XLAM文件中有一些UDF.当XLAM作为外接程序安装时，Intellisense似乎没有使用这些UDF. UDF本身可以在Excel中正常工作，只是它们没有出现在智能感知中.在这里，我的意思是在工作表上使用智能感知.

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.

推荐答案

(无法)无法获得UDF(VBA，XLL等)来提供智能感知.经常向Excel团队建议这样做，这是值得改进的.

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.

(请参阅 https://fastexcel.wordpress.com/2016/10/07/writing-efficiency-vba-udfs-part-15-adding-intellisense-to-your-udfs/)

这篇关于如何获得Intellisense来处理XLAM文件中的UDF?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！