Paramters or Argument Auto-Label/Balloon Tip for User-DefinedFunction

[Andrew.D.Robertson]

Hi,

I am trying to create an auto-label to display the valid parameters
that would appear when you enter a user defined function into a
worksheet, much the same way that a label appears when you type:


"=sum("


and then the following label appears below the active cell:


"Sum(number1, [number2],...)"


I would like a lable like this to appear, with text I define, when I
input my user-defined function into a worksheet. Specifically it is
the automatic text that appears as you type in
the first bracket "(" in the spreadsheet. It's a little blue label
that appears underneath the active cell.


Can anyone help?


Thanks!

 

[Tom Hutchins]

This link may be helpful to you:
http://www.dicks-blog.com/archives/2006/02/17/registering-a-user-defined-function-with-excel/

I don't know if Excel 2007 has provided a good way for you to define help
for a UDF.

Hope this helps,

HUtch