效果如下
第一步下载,智能提示显示xll文件
Releases · Excel-DNA/IntelliSense (github.com)
xll文件报病毒解决办法
默认情况下,Excel 正在阻止不受信任的 XLL 加载项 - Microsoft 支持
第二步,加载xll文件,xll文件放在excel插件目录:%appdata%\Microsoft\AddIns
第三步编写excel vba函数
外部 .intellisense.xml 文件
Any Workbook, .xlam add-in or .xll add-in (native or managed) can provide an external file with the IntelliSense function descriptions. This file should have the same base name and path as the Workbook or add-in, but have the extension .intellisense.xml
.
任何工作簿、.xlam 加载项或 .xll 加载项(本机或托管)都可以提供带有 IntelliSense 函数描述的外部文件。此文件应具有与工作簿或加载项相同的基本名称和路径,但具有扩展名.intellisense.xml
。
For example, the MyFuncs.xlam would have function descriptions in a file called MyFuncs.intellisense.xml in the same folder.
例如,MyFuncs.xlam 将在同一文件夹中名为 MyFuncs.intellisense.xml 的文件中包含函数描述。
The content of the .xml file would be exactly the same as the Custom XML part described above.
.xml 文件的内容与上述自定义 XML 部分完全相同。
第四步编写参数提示xml文件 格式如下
<IntelliSense xmlns="http://schemas.excel-dna.net/intellisense/1.0">
<FunctionInfo>
<Function Name="MyVBAFunction" Description="A function described in XML"
HelpTopic="http://www.bing.com" >
<Argument Name="FirstArg" Description="Whatever you want to put in here" />
<Argument Name="AnotherArg" Description="Actually the second arg" />
</Function>
<Function Name="AnotherFunction" Description="A function described in XML"
HelpTopic="http://www.bing.com" >
<Argument Name="FirstArg" Description="Whatever you want to put in here" />
<Argument Name="AnotherArg" Description="Actually the second arg" />
</Function>
</FunctionInfo>
</IntelliSense>
标签:xml,文件,vba,xll,自定义,Excel,intellisense,IntelliSense From: https://www.cnblogs.com/NanShengBlogs/p/18365420