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
|