Tool tips on UDF

[Bjarte]

Hi
I'm making a function in VBA.
When the user types a excel function into a cell some tool tip appares
to help on the parameters.
How can I make this to happen on my home-made functions.

I cant tell everyone what parameters they should use. My life is too
short for that.

Thanks
Bjarte

 

[merjet]

http://www.ozgrid.com/VBA/DesciptionToUDF.htm
shows how to add help for the function - which could
address the arguments - but adding help for each argument
separately is very difficult.

HTH,
Merjet

 

[Tom Ogilvy]

You can look at the information Laurent Longre has posted on his site about
this:

http://longre.free.fr/english/func_cats.htm

Newer addin that supports this:
http://longre.free.fr/english/index.html#FunCustomize