User Defined Function Parameter Descriptions

[Flyingmeatball]

I have a user defined function that works how I want, but I'm having trouble gettting the descriptions of the parameters to update. In the standard functions, if you click on a specific parameter of the function it gives a small description at the bottom. How do I update this? I've tried playing around with Applciation.MacroOptions, but can't get it to work correctly. Any help on creating those parameter descriptions would be much appreciated!

Thanks!

 

[Andrew Poulsom]

It's not straightforward:

http://www.jkp-ads.com/articles/RegisterUDF00.asp

unless you have Excel 2010:

http://spreadsheetpage.com/index.php...in_excel_2010/

 

[Kenneth Hobson]

There is no solution for the popup. You can type your function and then Ctrl+A or Ctrl+Shift+A.

 

[Flyingmeatball]

Thanks for the quick response! Yikes that isn't as simple as it should intuitively be...not quite sure why they don't have this in the properties box. Anyways, thanks for the help!