LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
short cut key of function of count in excel? Excel Excel Worksheet Functions 3 October 22nd 09 12:47 PM
Excel function same description but different result heng Excel Worksheet Functions 1 October 12th 05 07:51 AM
Function parameter description Davids Excel Programming 2 May 2nd 05 02:17 PM
The description of the ATAN2 function in Microsoft Excel is not 1. Celeste Excel Worksheet Functions 2 February 18th 05 03:00 PM
access function description from c++ Angelique[_2_] Excel Programming 0 October 29th 03 03:55 PM


All times are GMT +1. The time now is 08:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"