Custom Function

[Guest]

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?

 

[Guest]

Tools>Macro>Macros
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.

 

[Gord Dibben]

Spencer

You can add a brief description(not arguments) if you open the VBEditor and
View>Object 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