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
