If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
CanShrinkLines Custom Function | BertaHill | Setting Up & Running Reports | 0 | March 21st, 2005 08:07 PM |
Hi - RPC over HTTP problem: | MarkInIreland | Installation & Setup | 3 | March 13th, 2005 02:29 PM |
Custom Function & Personal.XLS | Worksheet Functions | 1 | July 30th, 2004 07:04 AM | |
Custom Function Problem | Phil Hageman | Worksheet Functions | 4 | July 27th, 2004 06:53 PM |
Writing a custom function | sue | Worksheet Functions | 2 | April 5th, 2004 06:02 PM |