View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
JP[_4_] JP[_4_] is offline
external usenet poster
 
Posts: 897
Default How do you document a function (like built in functions) in VBA?

Check out http://www.jkp-ads.com/Articles/RegisterUDF00.htm



HTH,
JP


On Aug 12, 12:37*pm, JY wrote:
I am create functions that will act as custom formulas in a spreadsheet and I
would like to have descriptions for each argument like it is found in the
Insert Function dialogs.

In addition Excel built in functions will provide a list of the arguments
when the function is typed into a cell.

Can a custom built formula be document in the same way?

Thanks
JY