记录Excel自动完成的VBA代码
在编写使用VBA的excel中使用自定义函数时，如何编写文档注释，以便自动填充公式时自动显示excel？
When writing a custom function to use in excel using VBA, How to write the documentation comments so that the excel automatically displays during auto-fill of a formula?
例如，当我们开始键入VLookUp时，它显示了Vlookup作为工具提示，显示输入变量名称，如果我们从功能区中按Insert功能，将显示一个对话框，清楚地说明了该功能...如何才能在VBA中编写自定义函数时实现这一点？
For example, when we start typing VLookUp, It shows what Vlookup does as a tool tip, shows the input variable names and if we press Insert Function from the ribbon, a dialog is shown with clear explanation of the function... How can we achieve that while writing custom functions in VBA?
我相信你必须使用 Application.MacroOptions 注册您的功能及其说明，并可选择提供一个帮助文件使这个功能的帮助链接工作。
I believe you must use Application.MacroOptions to register your function and its description, and optionally provide a help file to make the Help on this Function link work.
不知道如何提供参数的内联描述。
Not sure how to provide inline description for the parameters though.