User Defined function - Help
 

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)

User Defined function - Help
 

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)

User Defined function - Help
 

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)

User Defined function - Help
 

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.

User Defined function - Help
 

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.

User Defined function - Help
 

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

User Defined function - Help
 

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

User Defined function - Help
 

Hi Gord,

The link I gave to Jan Karel's site contains a further development, based on Laurents work and with contributions from KeepITCool.
This is really difficult stuff and it has taken years to get things stable. It seems to be so now, but even here are warnings all
over the place!

--
Kind regards,

Niek Otten
Microsoft MVP - Excel


"Gord Dibben" <gorddibbATshawDOTca wrote in message ...
| 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
|
|

User Defined function - Help
 

Thanks Niek

Confess I had not checked out the link you posted in the earlier post.

Will add it to my store.


Gord

On Wed, 27 Feb 2008 22:24:32 +0100, "Niek Otten" wrote:

Hi Gord,

The link I gave to Jan Karel's site contains a further development, based on Laurents work and with contributions from KeepITCool.
This is really difficult stuff and it has taken years to get things stable. It seems to be so now, but even here are warnings all
over the place!