Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to prevent short cuts from disappearing from tool tips? | Setting up and Configuration of Excel | |||
Tool Tips for UDFs? | Excel Discussion (Misc queries) | |||
VBA to add Tool Tips | Excel Discussion (Misc queries) | |||
tool tips | Excel Discussion (Misc queries) | |||
Tool tips for UDF | Excel Worksheet Functions |