效果如下
第一步下載，智慧提示顯示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檔案 格式如下
使用說明 · Excel-DNA/IntelliSense Wiki · GitHub --- Usage Instructions · Excel-DNA/IntelliSense Wiki · GitHub
<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>
