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?

custom function
 

go to the object browser in the VBE

find you function in the browser

right click on it and select properties

enter a description.

Close the object browser.

--
Regards,
Tom Ogilvy


"Spencer Hutton" wrote in message
...
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?