custom function

  • Thread starter Thread starter Spencer Hutton
  • Start date Start date
S

Spencer Hutton

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?
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Custom Function 2
Dynamic Table Problem 1
Custom functions using arguments with same name 5
How do I invoice a cost to a custom built MS Access Accounting Database? 0
VBA Excel - Select a value from one cell in Excel to update a SQL table 1
I need help with Numbers on Mac 0
How to use Implicit Intersection in a VBA Function 13
To assign list of number 2

Back
Top