如何让智能感知适用于 XLAM 文件中的 UDF？
我的 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.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（2）
没有办法让 UDF（VBA、XLL 等）提供智能感知。人们经常向 Excel 团队建议这是一项有价值的改进。
（参见https://fastexcel.wordpress.com/2016/10/07/writing-efficient-vba-udfs-part-15-adding-intellisense-to-your-udfs/）
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/)
通过 Excel-DNA IntelliSense 扩展，您可以为基于 VBA 的 UDF（以及来自 Excel-DNA、PyXLL 或 C/C++ 工具包之一的基于 .xll 的 UDF）添加表内 IntelliSense。
IntelliSense 扩展的公告和讨论如下：https://excel-dna.net/2016/11/24/excel-udf-intellisense-for-excel-dna-and-vba/
有关将表内 IntelliSense 添加到 VBA 项目的详细文章（作者 Charles Williams）可以在此处找到：https://fastexcel.wordpress.com/2016/10/07/writing-efficient-vba-udfs-part-15-adding-intellisense-to-your-udfs/
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/