Custom Function
 

I have written a simple VBA function:

Function SpenceTAX(Cost, Rate)
SpenceTAX = Cost + (Cost * Rate)
End Function

it adds tax to an items cost. how do i get a description of what the
function does to show up in the function dialog box in execl?

ToolsMacroMacros
You won't see your function listed, but you can type in the name of the
function

Then select Options and type in your description.

---------
Regards,
Ron

Spencer

You can add a brief description(not arguments) if you open the VBEditor and
ViewObject Browser.

Find your UDF and right-click and you can add a comment there.

To fully customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

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


Gord Dibben Excel MVP

On Fri, 29 Apr 2005 10:08:01 -0700, "Spencer Hutton"
wrote:

I have written a simple VBA function:

Function SpenceTAX(Cost, Rate)
SpenceTAX = Cost + (Cost * Rate)
End Function

it adds tax to an items cost. how do i get a description of what the
function does to show up in the function dialog box in execl?