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