Commenting custom formula fields/formula on formula editor

  • Thread starter Thread starter Muxer
  • Start date Start date
M

Muxer

When you build custom formulas w/ VBA, how do you comment the input fields?


Example: If you click on the edit formula button "=", then click on the
functions drop down box and let's say you select "sum" if you click on
the "Number1" field at the bottom of the formula editor shows a brief
explanation of the data to be typed and a description of the formula
itself. How does one do the same thing with code.

Regards!
 
the following code will give an overall description for your function,

Sub NameFuntion()
Application.MacroOptions macro:="Name of your Function",
Description:="Your Description"
End Sub

Not sure how to enter a description for each variable though
 
Gord said:
You could do this manually if you just want a description of the Function and
an example.

Tools>Macro>Macros. Type in the name of your Function then Optionst. Type in
a description as below.......

This Function Places the Workbook Created Date in a cell. usage is:
=CreaDate()

Note: You cannot enter arguments descriptions in this manner.

You could do it using Laurent Longre's FUNCUSTOMIZE.DLL downlaodable in a
*.ZIP file from his site. If you go this route, check out the Demo that comes
with it.

http://longre.free.fr/english/index.html#FunCustomize

Gord Dibben Excel MVP - XL97 SR2 & XL2002
Thanks guys!

Although this would do for now. I would still like to know how to give a
descrbtions of the variables. I will post ansewer if I find out.

Thanks again!
Muxer
 
Back
Top