Excel 2007 UDF Screentips

[D Dey]

Hi

I am creating user-defined functions (UDFs) for Excel 2007.

Excel 2007 has a new feature: formula autocomplete.

If you type in a function in a cell e.g. =A, then a list of all functions beginning with A appear, along with a "screentip"/"super-tooltip" (a kind of blue comment balloon on the right of the function autocomplete list, which explains what the function does). For example, "=A", first function on the list is ABS, with screentip "Returns the absolute value of the number, .."

I can get my UDFs to appear in this autocomplete list, but no screentip. How do I do this (example would be much appreciated!)?

The following blog http://blogs.msdn.com/excel/archive/2005/10/19/482826.aspx suggests this can be done but only via XLLs- but does not explain how. (See reply Friday, October 21, 2005 7:01 PM by David Gainer) My UDFs are in an XLL. (In my XLL, there are only 11 parameters which I can register- but the descriptions only appear in the function wizard, not as a screentip).

Further is it possible to acheive this without an XLL, e.g. auatomation (VSTO) add-ins?

Thanks

Debs

Edited February 24, 2009 by D Dey

[xper]

Please next time post your question in proper forum.

Thnk you and Welcome to MSFN