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 Dibben wrote:
> 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
>
>
> On Mon, 21 Jul 2003 22:08:48 GMT, Muxer <(E-Mail Removed)> wrote:
>
>
>>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!
>
>
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