Thread: custom function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default 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?