PDA

View Full Version : Function Tips



mdmackillop
01-28-2006, 05:01 AM
There have been a few User Defined Functions submitted as KB entries recently. Is it possible for Excel to show Function Tips for UDFs the way it does for built-in functions?
Regards
MD

XLGibbs
01-28-2006, 06:43 AM
Yes, but you have to put them in the excel sheet where you would assign shortcuts...ALT-F8 > EDIT > Options

YOu can type the description there.......I have not yet figured out how to do that bit programattically yet though...but that is where the option is to put a description of the function...

XL-Dennis
01-28-2006, 06:56 AM
Hi guys,

Mr Laurent Longre have an add-in that may be useful in this context:

http://xcell05.free.fr/ (Click on the English-button)

Kind regards,
Dennis

Justinlabenne
01-28-2006, 11:48 AM
If I am on track with what you are asking for.......you can use MacroOptions to assign some basic text about what the function does....there are some others methods I have seen, but none reliable besided the method Laurent Longre provides in Dennis's link

mdmackillop
01-28-2006, 12:13 PM
Thanks all,
It was this display I was thinking of.

Norie
01-28-2006, 01:12 PM
Is that display a new feature?

I don't seem to have it in Excel 2000.

mdmackillop
01-28-2006, 02:06 PM
It's a 2003 feature. I happened across a blog on Excel 12, and I see that Intellisense is coming to the worksheet, so maybe I'll just have to wait.

matthewspatrick
01-29-2006, 11:23 AM
Is that display a new feature?

I don't seem to have it in Excel 2000.

It was implemented in XL2002 aka XP.

Patrick

mdmackillop
02-03-2006, 02:05 AM
I'm guessing this can't be done, or in any case not easily.
Thanks for the help.
Regards
MD