View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
swiftcode swiftcode is offline
external usenet poster
 
Posts: 36
Default 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