Dear All,

I created a custom function and would like the argument definitions t
appear in the standard excel function dialog box.

Consider a function RectangleSize (Base as double, Height as double)

When I click on the 'fx' symbol in the speadsheet, the Functio
Argument dialog box pops up. I would like to set-up the pop-up so tha
the help/definition of "base" and "Height" appear at the bottom whe
the user clicks on a particular argument.

e.g.: "Base represents the base of your rectangle, etc."

I was able to set the help/definition for the entire funtion but no
for the individual arguments...

This must be fairly common but I could not find any reference to thi
feature so far.

Any idea?

Thanks a lot for your help!

Sincerely,

fmo

--
Message posted from http://www.ExcelForum.com

Visit

http://longre.free.fr/

where you will find a recipe

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"fmoi1 " wrote in message
...
Dear All,

I created a custom function and would like the argument definitions to
appear in the standard excel function dialog box.

Consider a function RectangleSize (Base as double, Height as double)

When I click on the 'fx' symbol in the speadsheet, the Function
Argument dialog box pops up. I would like to set-up the pop-up so that
the help/definition of "base" and "Height" appear at the bottom when
the user clicks on a particular argument.

e.g.: "Base represents the base of your rectangle, etc."

I was able to set the help/definition for the entire funtion but not
for the individual arguments...

This must be fairly common but I could not find any reference to this
feature so far.

Any idea?

Thanks a lot for your help!

Sincerely,

fmoi


---
Message posted from http://www.ExcelForum.com/