Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Short Description in my Excel VBA Function Dialog Box
Hi,
My question is, how do i inlclude a short description of my arguments, in the Function formula dialog box that appears when i click on the "FX" icon, e.g. for BuyCCY, the description is "BuyCCY is the currency bought". I have a function as below : Function FX_SWAP_CALC(BuyCCY, BuyNotional, _ SellCCY, SellNotional, _ ExRate, SpotRate) CCYType = UCase(BuyCCY) & "/" & UCase(SellCCY) Select Case CCYType Case "AUD/USD" Calc = (BuyNotional * ExRate) - SellNotional Case "USD/AUD" Calc = BuyNotional - (SellNotional * ExRate) Case "TWD/USD" Calc = (BuyNotional / ExRate) - SellNotional Case "USD/TWD" Calc = BuyNotional - (SellNotional / ExRate) End Select Application.Volatile True FX_SWAP_CALC = Round(Calc, 2) End Function |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Short Description in my Excel VBA Function Dialog Box
Hi SwiftCode,
This is not natively supported in Excel but you may like to look at Laurent Longre's Funcustomize add-in which is freely downloadable at: http://xcell05.free.fr/ --- Regards, Norman "swiftcode" wrote in message ... Hi, My question is, how do i inlclude a short description of my arguments, in the Function formula dialog box that appears when i click on the "FX" icon, e.g. for BuyCCY, the description is "BuyCCY is the currency bought". I have a function as below : Function FX_SWAP_CALC(BuyCCY, BuyNotional, _ SellCCY, SellNotional, _ ExRate, SpotRate) CCYType = UCase(BuyCCY) & "/" & UCase(SellCCY) Select Case CCYType Case "AUD/USD" Calc = (BuyNotional * ExRate) - SellNotional Case "USD/AUD" Calc = BuyNotional - (SellNotional * ExRate) Case "TWD/USD" Calc = (BuyNotional / ExRate) - SellNotional Case "USD/TWD" Calc = BuyNotional - (SellNotional / ExRate) End Select Application.Volatile True FX_SWAP_CALC = Round(Calc, 2) End Function |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Short Description in my Excel VBA Function Dialog Box
From a previous post by Dave Peterson (in this example the UDF was called
buscarv): Back to Excel tools|macro|macros type in your function name then click the Options button Add your description to that description box. click ok then click Cancel Then you can hit that Fx button (or ctrl-a) after you've typed: =buscarv( in the formula bar. And if you name your variables very nicely, you can type: =buscarv( and hit ctrl-shift-a and you'll see your list of variable names With nice names, sometimes the Fx/ctrl-a wouldn't be necessary. Hope this helps Rowan "swiftcode" wrote: Hi, My question is, how do i inlclude a short description of my arguments, in the Function formula dialog box that appears when i click on the "FX" icon, e.g. for BuyCCY, the description is "BuyCCY is the currency bought". I have a function as below : Function FX_SWAP_CALC(BuyCCY, BuyNotional, _ SellCCY, SellNotional, _ ExRate, SpotRate) CCYType = UCase(BuyCCY) & "/" & UCase(SellCCY) Select Case CCYType Case "AUD/USD" Calc = (BuyNotional * ExRate) - SellNotional Case "USD/AUD" Calc = BuyNotional - (SellNotional * ExRate) Case "TWD/USD" Calc = (BuyNotional / ExRate) - SellNotional Case "USD/TWD" Calc = BuyNotional - (SellNotional / ExRate) End Select Application.Volatile True FX_SWAP_CALC = Round(Calc, 2) End Function |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Short Description in my Excel VBA Function Dialog Box
Hi Guys,
Thanks for the quick response. Norman, I think i have to agree with you, i don't think it is possible, unless we create our our dialog box to support the function. Rowan, Your mentioned method only allows for the general description to be displayed at the lower section of the dialog box, that was not what i wanted, i wanted something more dynamic, for each of the arguments to have its own description when the "pointer" or position of the cursor is at the input box. Thank you n have a good day. "Rowan" wrote: From a previous post by Dave Peterson (in this example the UDF was called buscarv): Back to Excel tools|macro|macros type in your function name then click the Options button Add your description to that description box. click ok then click Cancel Then you can hit that Fx button (or ctrl-a) after you've typed: =buscarv( in the formula bar. And if you name your variables very nicely, you can type: =buscarv( and hit ctrl-shift-a and you'll see your list of variable names With nice names, sometimes the Fx/ctrl-a wouldn't be necessary. Hope this helps Rowan "swiftcode" wrote: Hi, My question is, how do i inlclude a short description of my arguments, in the Function formula dialog box that appears when i click on the "FX" icon, e.g. for BuyCCY, the description is "BuyCCY is the currency bought". I have a function as below : Function FX_SWAP_CALC(BuyCCY, BuyNotional, _ SellCCY, SellNotional, _ ExRate, SpotRate) CCYType = UCase(BuyCCY) & "/" & UCase(SellCCY) Select Case CCYType Case "AUD/USD" Calc = (BuyNotional * ExRate) - SellNotional Case "USD/AUD" Calc = BuyNotional - (SellNotional * ExRate) Case "TWD/USD" Calc = (BuyNotional / ExRate) - SellNotional Case "USD/TWD" Calc = BuyNotional - (SellNotional / ExRate) End Select Application.Volatile True FX_SWAP_CALC = Round(Calc, 2) End Function |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
short cut key of function of count in excel? | Excel Worksheet Functions | |||
Excel function same description but different result | Excel Worksheet Functions | |||
Function parameter description | Excel Programming | |||
The description of the ATAN2 function in Microsoft Excel is not 1. | Excel Worksheet Functions | |||
access function description from c++ | Excel Programming |