MacroOptions method

[pmover]

i wish to utilize the MacroOptions method for creating descriptions for user defined functions.
my PC uses OSX Yosemite (ver 10.10.5), Excel for Mac 2011, and VBA (14.6.5).

I followed the example at this link:

http://www.myengineeringworld.net/2013/07/add-description-to-custom-vba-function.html

Unfortunately, an error "Compile error: Named argument not found" is generated when using the parameter argumentdescription for the MacroOptions method. this leads me to believe that this parameter is not available for this OSX + application version as seen in this image.

what are other options available for creating the descriptions?

thanks!

 

[SkipVought]

Hi,

That argument name is PLURAL: ArgumentDescriptions.

expression .MacroOptions(Macro, Description, HasMenu, MenuText, HasShortcutKey, ShortcutKey, Category, StatusBar, HelpContextID, HelpFile, ArgumentDescriptions)

expression A variable that represents an Application object.

Please note that this feature is only applicable for Office 2013 and later.

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]