Documenting VBA code for Excel Auto Complete

Question

When writing a custom function to use in excel using VBA, how do I write documentation comments so that excel automatically displays when the formula is autocompleted?

For example, when we start typing VLookUp, it shows what Vlookup does as a hint, shows the names of input variables, and if we press Insert Function from the ribbon, a dialog box appears with a clear explanation of the function ... How can we achieve this when writing custom functions in VBA?

Answer 1

I believe that you should use Application.MacroOptions to register your function and its description, and, if desired, provide a help file so that the link to the Help for this function works.

Not sure how to provide a built-in parameter description though.

Answer 2

I have seen this question several times, and so far there has been no answer.

I am afraid that this is simply impossible (at least for Excel 2007, not sure in 2010).