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

Question

VBA solutions can vary widely in size.

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

Answer 1

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.

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

Answer 2

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.