Depends what you mean by hints/prompts, AFAIK there is no utility out there
that will help you add tooltips or autocomplete to your UDFs.

For info and help text in the function wizard go for the link given by Gord
Dibben. If you need to include more that total 255 characters of info text,
a brilliant method is described here (not easy though)

http://www.jkp-ads.com/articles/RegisterUDF01.asp

Regards,
Peter T

"David" wrote in message
...
I'm trying to get hints/prompts to display for a UDF I've written.

This group had a thread back in 2007 that had the answer, but the link
I found is now dead. Here's the question/answer I found and the old
link. Can anybody provide and answer or a link to the archived
answer.

TIA,
David

------------------------------------------------------------------------------------------
http://groups.google.com/group/micro...6f0180ce2819d5
--
Gary''s Student - gsnu2007a


"michael.beckinsale" wrote:

Hi All,

With XL2003 built in functions you get prompts for the various
parameters / arguments as you type into the cell.

eg typing =Sumif( directly into a cell results in this prompt:

SUMIF(range, criteria,[sumrange])

Can this be achieved with UDF and if so how?

Regards

Michael B.



---------------------------------------------------------------------------------------------------------------------------