Display custom function's description (Excel for Mac 2011 VBA)

Question

Hi:

I'd like to insert a description of what a custom function I created in VBA does somehow so that when one chooses "Insert Function" and scrolls down to the User Defined section a nice description of what this function does pops up in the "Description" window. I can find instructions for how to do this in PC versions of Excel, but nothing in the Mac version.

Any help would be greatly appreciated. Thank you!

Answer 1

Following up on Rich's answer...

After typing your tool tip into the Description field of the Macro Options dialog, click OK to exist the Macro Options dialog, but then click the Cancel button to exit the Macro dialog box. This is counterintuitive, but clicking the Cancel button actually registers the tool tip.

Save the workbook, and then re-open the workbook and you will see your tool tip in the Formula Builder.

Answer 2

After writing the VBA User Defined Function (UDF) go to the Developer tab and select the Macros button. Since your UDF macro is a "Function" it will not appear in the list of Macros. However, if you type the name of the Function into the "Macro name" text box the "Options" button will enable on the dialog.

Click Options and in the dialog that opens you can enter the Tooltip.

Hope this helps

Answer 3

Thanks for quick reply. Will try next week when I get some office time and let you know. Much appreciated!

Answer 4

Interestingly enuf, clicking either "OK" or "Cancel" seemed to work and store the function description. Thanks much to you both!!!

Answer 5

Is there a method to do this programmatically?  We have a small library of user functions and use the "Application.MacroOptions" feature in VBA to register this information under Windows, but this function is not recognized by MAC VBA.  Is there an alternative?