Suppose i have a function, i want a description to appear like when using excel built-in function. My question is how to put a tooltip for the function and for the parameters so that as i type it in excel, it appears. Thanks in Advance guys.
You help me i give you reps.
A detailed explanation: How to add a Tool Tip to User Defined Functions
http://www.jkp-ads.com/Articles/RegisterUDF00.asp
Last edited by JBeaucaire; 08-05-2013 at 10:09 AM.
_________________
Microsoft MVP 2010 - Excel
Visit: Jerry Beaucaire's Excel Files & Macros
If you've been given good help, use theicon below to give reputation feedback, it is appreciated.
Always put your code between code tags. [CODE] your code here [/CODE]
?None of us is as good as all of us? - Ray Kroc
?Actually, I *am* a rocket scientist.? - JB (little ones count!)
you cannot add a tooltip to a function only information in the function wizard as JB indicated
Josie
if at first you don't succeed try doing it the way your wife told you to
Actually in 2010 you can do it, and that link has a hack for earlier versions, too, one that works if your willing to get in there and do it.
Since UDFs are designed by the user, I've never really found any of this needful.
no, you can't. you can add argument descriptions to the function wizard but you cannot add the tooltip you get when entering a native function in a cell. unless you can make me very happy by proving otherwise?
udfs are as often as not created by developers rather than end users most of whom do not know what a udf is let alone how to create one ;-)
You're right, I completely mixed up the ToolTip idea and the Function Wizard descriptions. ToolTips are still impossible for UDFs.
The closest I've ever seen is this https://github.com/Excel-DNA/IntelliSense, though granted it may take some people out of their comfort zone
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks