Tool tips on UDF
 

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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

Tool tips on UDF
 

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

Tool tips on UDF
 

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

--
Regards,
Tom Ogilvy


Bjarte wrote in message
...
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



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/