Documenting VBA code for Excel Auto Complete

Question

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?

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?

You may wish to try: http://stackoverflow.com/questions/4262421/how-to-put-a-tooltip-on-a-user-defined-function/4262521#4262521 — Fionnuala, Jul 07 '13 at 19:24

score 5 · Accepted Answer · answered Mar 12 '11 at 11:38

5

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.

answered Mar 12 '11 at 11:38

GSerg

76,472
17
159
346

score 0 · Answer 2 · edited Jul 07 '13 at 19:25

0

I've seen this question a few times, and so far no answer has been provided.

I'm afraid it's just not possible (at least for Excel 2007, not sure about 2010).

edited Jul 07 '13 at 19:25

Fionnuala

90,370
7
114
152

answered Mar 12 '11 at 14:24

Tiago Cardoso

2,057
1
14
33

Documenting VBA code for Excel Auto Complete

2 Answers2

Linked