Add description to UDF argument

[F.H. van Zelm]

Hi,

After writing a user defined function, I know how
- to add a general description
(like Sum has 'Adds all the numbers in a tange of cells.')
- to place the function in category
(with MacroOptions

But how to add a description to an argument, like SUM
has 'Number1: number1, number2, number3 ... are etc.'?

On www.bettersolutions/excel, I found a complex work
around by registering the functions.
Is there a simple way to do the trick? I sure hope so.

 

[Niek Otten]

Hi Frans,

There are several articles about this on the Internet. Several of them have problems.
The most reliable solution I'm aware of is from Jan Karel Pieterse. It is certainly not easy. But try following his recipe:

http://www.jkp-ads.com/Articles/RegisterUDF00.htm

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Hi,
|
| After writing a user defined function, I know how
| - to add a general description
| (like Sum has 'Adds all the numbers in a tange of cells.')
| - to place the function in category
| (with MacroOptions
|
| But how to add a description to an argument, like SUM
| has 'Number1: number1, number2, number3 ... are etc.'?
|
| On www.bettersolutions/excel, I found a complex work
| around by registering the functions.
| Is there a simple way to do the trick? I sure hope so.
|
| --
| Mvg, Frans
|
|