将帮助添加到“无可用帮助” Excel,VBA,用户自定义函数 [英] Add help to "No help available" Excel, VBA , User defined functions
问题描述
我正在使用VBA(Visual Basic for Applications)编写的Excel中的用户定义函数(UDF)添加一些帮助。我知道如何添加一个描述。任何想法,我可以添加帮助在蓝色链接帮助这个功能,没有它导致一个MsgBox,无帮助可用?
您必须先创建一个帮助文件。然后,您可以使用 Application.MacroOptions
将帮助文件附加到函数
例如
Application.MacroOptions Macro:=MyFunction,_
类别:=我的自定义类别,_
HelpFile: =C:\MyHelp.chm,_
HelpContextID:= 1
<我们通常使用帮助和手册6 为我的项目创建我的帮助文件。这是我为上面的例子创建的一个例子。当我点击帮助在这个功能,看看我该怎么做...
免责声明:我没有连接到帮助和Manual6 以任何方式,但我喜欢他们的产品(它不是免费的)。您可能只需在网络上找到可以为您创建chm文件的免费软件,以便我们决定如何选择帮助文件。
I was trying to add some help to my user-defined function(UDF) in Excel, written using VBA(Visual Basic for Applications). I know how to add a description.Any idea how I can add help at the blue link "Help on this function" and not have it lead to a MsgBox that reads "No help available" ?
You have to first create a help file. You can then use Application.MacroOptions
to attach the help file to the function
For example
Application.MacroOptions Macro:="MyFunction", _
Category:="My Custom Category", _
HelpFile:="C:\MyHelp.chm", _
HelpContextID:=1
EDIT: Adding More Information
I usually use Help and Manual6 to create my help files for my projects. Here is one example that I created for the above example. And when I click on the "Help On this Function", see what do I get...
DISCLAIMER: I am not connected to Help and Manual6 in any way but I like their product (It is not free). You might just find a freeware on the web which can make chm files for you so I leave the decision with you on how you choose to make the help file.
这篇关于将帮助添加到“无可用帮助” Excel,VBA,用户自定义函数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!