My User Defined function appears on the insert function wizard under User
defined. Nice.
If I select my function, it asks for the function arguments. Nice.

But it says "No help available".
It would be VERY nice to be able to provide a sentence or two of
help/documentation in this section.

Is it possible?

(Excel 97, Windows XP)

See:

http://www.jkp-ads.com/Articles/RegisterUDF00.htm
--
Gary''s Student - gsnu200770


"makulski" wrote:

My User Defined function appears on the insert function wizard under User
defined. Nice.
If I select my function, it asks for the function arguments. Nice.

But it says "No help available".
It would be VERY nice to be able to provide a sentence or two of
help/documentation in this section.

Is it possible?

(Excel 97, Windows XP)

No easy stuff, but it can be done. Look at Jan Karel Pieterse's article:

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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"makulski" wrote in message ...
| My User Defined function appears on the insert function wizard under User
| defined. Nice.
| If I select my function, it asks for the function arguments. Nice.
|
| But it says "No help available".
| It would be VERY nice to be able to provide a sentence or two of
| help/documentation in this section.
|
| Is it possible?
|
| (Excel 97, Windows XP)

Thanks you Gary and Niek. You both pointed me at the same article.
I think I tripped across a version of this on an earlier crawl, and I chose
not to proceed, because of descriptive words like "Trickery", "flakey", "XL97
secret undocumented feature", "unsupported", "unofficial" and "hangs
occasionally".

I may actually try it for fun, but I think if I tried using this in an
official capacity, I might as well hand Mordant-the-preventor my testicles
right now.

Anyway, it would be nice if microsoft were to provide some official facility
for better documenting UDFs.

If all you need is a line or two to describe the UDF try this.

ToolsMacroMacros

Type in the name of the UDF and "Options"

You can type in a couple of descriptive lines and OK then Cancel


Gord Dibben MS Excel MVP

On Tue, 26 Feb 2008 14:27:01 -0800, makulski
wrote:

Thanks you Gary and Niek. You both pointed me at the same article.
I think I tripped across a version of this on an earlier crawl, and I chose
not to proceed, because of descriptive words like "Trickery", "flakey", "XL97
secret undocumented feature", "unsupported", "unofficial" and "hangs
occasionally".

I may actually try it for fun, but I think if I tried using this in an
official capacity, I might as well hand Mordant-the-preventor my testicles
right now.

Anyway, it would be nice if microsoft were to provide some official facility
for better documenting UDFs.

All right! Yes, that worked great.
One doesn't see the udf in the macro list because it doesn't list finctions,
only subs. But typing the name in gets you there.
And the description now shows in the Insert function wizzard. That's 90% of
what I wanted. Thanks.
(agrument descriptions and detailed help are the other 10%)

"Gord Dibben" wrote:

If all you need is a line or two to describe the UDF try this.

ToolsMacroMacros

Type in the name of the UDF and "Options"

You can type in a couple of descriptive lines and OK then Cancel


Gord Dibben MS Excel MVP

To fully customize your User Defined Functions....

See Laurent Longre's website for FUNCUSTOMIZE add-in.

ZIP file also includes a demo file and a how-to-use file.

http://longre.free.fr/english/index.html

Ballon Tips are not available with Laurent's method.


Gord Dibben Excel MVP

On Wed, 27 Feb 2008 10:49:02 -0800, makulski
wrote:

All right! Yes, that worked great.
One doesn't see the udf in the macro list because it doesn't list finctions,
only subs. But typing the name in gets you there.
And the description now shows in the Insert function wizzard. That's 90% of
what I wanted. Thanks.
(agrument descriptions and detailed help are the other 10%)

"Gord Dibben" wrote:

If all you need is a line or two to describe the UDF try this.

ToolsMacroMacros

Type in the name of the UDF and "Options"

You can type in a couple of descriptive lines and OK then Cancel


Gord Dibben MS Excel MVP