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

There is no alternative that I am aware of. Application.MacroOptions was new in Excel 2010 for Windows. The Mac team has had plenty of time to implement it in Excel for the Mac.

About all you can do is send feedback explaining to Microsoft the business case for supporting Application.MacroOptions in VBA on the Mac and how not having the expected support affects you and your users. Telling Microsoft the number of affected users is always important.

http://www.microsoft.com/mac/product-feedback

I tested in 2011 and 2016 versions of Excel on the Mac. Even in 2016 it is still not supported. You can express your wish for support in Excel 2016 at this site:

Excel for Mac