Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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
Posted to microsoft.public.excel.programming
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Emulate Index/Match combo function w/ VBA custom function | Excel Worksheet Functions | |||
custom function - with built-in function | Excel Programming | |||
Help with Custom Function | Excel Programming | |||
Custom Function | Excel Programming | |||
Adding a custom function to the default excel function list | Excel Programming |