为 Excel VBA 解决方案创建用户帮助文档的最佳方法是什么?

声明:本页面是StackOverFlow热门问题的中英对照翻译,遵循CC BY-SA 4.0协议,如果您需要使用它,必须同样遵循CC BY-SA许可,注明原文地址和作者信息,同时你必须将它归于原作者(不是我):StackOverFlow 原文地址: http://stackoverflow.com/questions/176690/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me): StackOverFlow

提示:将鼠标放在中文语句上可以显示对应的英文。显示中英文
时间:2020-09-11 09:58:07  来源:igfitidea点击:

What is the best way to create user help documentation for an Excel VBA solution?

excelexcel-vbaofficedevvba

提问by Robert Mearns

VBA solutions can vary widely in size.

VBA 解决方案的大小可能有很大差异。

I would like to add user helpdocumentation to all solutions but the level of effort to create and deploy the helpneeds to match the size of the solution.

我想将用户帮助文档添加到所有解决方案中,但创建和部署帮助的努力程度需要与解决方案的大小相匹配。

回答by Philippe Grondier

You should check the VBA version of MZ-Tools. It is an add-in for VBA that can automatically generate documentation from your code (function name, parameters, comments, subject, etc.). You can also use it to automatically generate line numbers, onError labels, etc. More on the automatic documenting feature can be found here.

您应该检查MZ-ToolsVBA 版本。它是 VBA 的一个插件,可以从您的代码(函数名称、参数、注释、主题等)自动生成文档。您还可以使用它来自动生成行号、onError 标签等。可以在此处找到有关自动记录功能的更多信息

It is free, easy, and very efficient. Once you notice how much you save time by using it, please do like me: donate.

它是免费的,简单的,而且非常有效。一旦您注意到使用它可以节省多少时间,请像我一样:捐赠。

回答by Fionnuala

You may wish to consider HTML Help. It allows you to produce help files that are similar to standard Microsoft help. It is not particularly difficult to use, for the most part.

您可能希望考虑HTML 帮助。它允许您生成类似于标准 Microsoft 帮助的帮助文件。大多数情况下,它不是特别难使用。