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

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

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

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